Cleaning up VLOOKUP formula with possible matrix code

**winnkys** · 01-15-2009, 10:25 PM

Hi,

I have looked at some posts but I can’t seem to find anything to help me.

I am wondering if there is an easier way to look up values in a matrix. I use the VLOOKUP with the vertical values as the lookup_value, then another lookup for the col_index_number to find the horizontal values.
The example in the attached file is just a sample of my spreadsheet. I need to apply this to a roughly 10*10 matrix (which changes every now and then) and apply this matrix to over 1,200 rows.

Is there an easy way to returne theses values or is the way I am currently doing it the best option.

Cheers,

Ryan

**solomon2211** · 01-15-2009, 11:27 PM

You have just change D2=VLOOKUP(PROPER(TRIM(B2)),$F$2:$J$6,MATCH(TRIM(C2),$G$2:$J$2,0)+1,FALSE)

Or D2=INDEX($G$3:$J$6,MATCH(TRIM(B2),$F$3:$F$6,0),MATCH(TRIM(C2),$G$2:$J$2,0))