=INDIRECT("W"&formula)

replace formula with your match function that returns 21.

"carl43m" wrote:

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.