Getting a value from a cell that is determined by a formula

C

carl43m

I used the Match function to find a specific value in a column of values. The
function tells me that I found the specific value in row 21. I now want to
go to column w and get the value in w21. However, I can't seem to find
anywhere how I could use the value determined with the match function and
attach it to the letter w to get w21. The specific value in my column list
can varry so I need to be able to search for the value with match and then go
get another piece of information from column w based on the value found from
Match.
 
N

Niek Otten

=INDEX(W1:W100,YourMatchFunction)

Change W110 to suit your case

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


|I used the Match function to find a specific value in a column of values. The
| function tells me that I found the specific value in row 21. I now want to
| go to column w and get the value in w21. However, I can't seem to find
| anywhere how I could use the value determined with the match function and
| attach it to the letter w to get w21. The specific value in my column list
| can varry so I need to be able to search for the value with match and then go
| get another piece of information from column w based on the value found from
| Match.
 
N

Niek Otten

<W110>

W100 of course

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| =INDEX(W1:W100,YourMatchFunction)
|
| Change W110 to suit your case
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
|
||I used the Match function to find a specific value in a column of values. The
|| function tells me that I found the specific value in row 21. I now want to
|| go to column w and get the value in w21. However, I can't seem to find
|| anywhere how I could use the value determined with the match function and
|| attach it to the letter w to get w21. The specific value in my column list
|| can varry so I need to be able to search for the value with match and then go
|| get another piece of information from column w based on the value found from
|| Match.
|
|
 
Top