Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel lookup and reference question 1

Status
Not open for further replies.

marduk813

Programmer
Joined
Jul 18, 2002
Messages
89
Location
US
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
 
Try the Match() function.
Set 3rd parameter = 0 for exact match
returns relative position (starting from 1) of the "match"
 
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!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top