Hello all,
I have a lookup problem that relies on 2 values. So rather than changing the column lookup depending on the second value is it possible to do it automatically?
I'm assuming it will be using index but I'm not too sharp on these.
Attached file... should explain what i mean.
Thanks
hi there. and your desired outcome for those cells are? my guess:
=INDEX(Sheet2!$B:$D,MATCH($A2,Sheet2!$A:$A,0),MATCH($B2,Sheet2!$B$1:$D$1,0))
but "X" will not work because your "X" in Sheet1 has an extra space while Sheet2 does not.
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
So in sheet1, where it's part 123 and type X, using sheet 2 I'd like the value to be returned in C2 (Sheet1) to be 50.
Any other suggestions
What benishiryo said is the correct way to do this.
Why are you looking for alternatives?
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
If I'm honest I have no idea how to work it, and without it in the sheet, I can't see how it works
=INDEX(Sheet2!$B:$D,MATCH($A2,Sheet2!$A:$A,0),MATCH($B2,Sheet2!$B$1:$D$1,0))
Looking at the table in Sheet2! columns B to D,
Searches for the value in A2 within Sheet2!column A, this gives us the row number
Searches for the value in B2 within Sheet2!row 1 form column B to D, this gives us the coluimn number
Reads the value at the intersection of the found row/column numbers
Do a Google INDEX and MATCH
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks