Hi
I'm looking for a lookup formula that looks horizontal and vertical ranges. If you see the attached file how would i get a value in D12 just say?
Thanks
Hi
I'm looking for a lookup formula that looks horizontal and vertical ranges. If you see the attached file how would i get a value in D12 just say?
Thanks
In B11 Cell
=IFERROR(VLOOKUP(B$10,$A$2:$E$6,MATCH($A11,$A$1:$E$1,0),FALSE),"")
Drag it down and right....
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
A simple INDEX & MATCH does it: in cell B11 put =INDEX($B$2:$E$6,MATCH($A11,$B$1:$E$1,1),MATCH(B$10,$A$2:$A$6,0)) drag across and down
Sorry I made a mistake ... please ignore this. Cheers
Last edited by Ursul; 01-09-2014 at 06:50 AM.
Glad it helps you and thanks for the feedback
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks