Excel lookup and reference question 1

[marduk813]

I'm sure someone has asked this before, but with the Keyword Search down at the moment, I haven't been able to find a similar question.

I need to look up a value in an array, based on the values looked up in columns and rows. For example, I have a row of values (B13:F13) and a column of values (A14:A19). I need to look up a value in the row and find which column it is in, then I need to look up a value in the first column and find which row it is in. What I'm trying to do is get the address of the cell that contains the data I need.

I haven't been able to use HLookup or VLookup to return the row or column number that the data was found in. I could swear that I'd found a way to do this before, but I can't for the life of me remember how I did it.

Thanks in advance,

Jas

 

[petroffp]

Try the Match() function.
Set 3rd parameter = 0 for exact match
returns relative position (starting from 1) of the "match"

 

[marduk813]

Thanks petro. I had looked at the Match function, but I didn't think it would do what I wanted; however, I was mistaken. Now my formula works great using a combination of VLookup and Match (for the column number from which to return the VLooked-up value).
Thank you very much!