The only way I know of to look up a value in a large matrix is to do a VLookup nested inside a HLookup similar to this:
" =HLOOKUP(D638,'Tab X'!$F$10:$X$281,(VLOOKUP(C638,'Tab X'!$B$1:$X$281,3,FALSE)-9),FALSE) "
Column 3 has the row numbers repeated (Row 130 says "130" in that 3rd Column)
-9 is the # of rows down to the value to return
Is there an easier way to do a vertical and horizontal lookup to return a value from the matrix?
Hello,
not sure if this is what you're after, but maybe with Index/Match
=index(A3:Z100,match(A1,A3:A100,0),match(A2,B3:Z3,0))
A sample workbook might help.
cheers,
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks