Lookup help!!
Hey thanks allot I was looking at your formula and I typed in one wrong
column it works perfect thanks so much. I am however not real sure on
understanding the index and match but thanks again
"mbarron" wrote:
You can do this by combining the Index and Match functions
=INDEX(your range,MATCH(row value,rows to look in),MATCH(column
value,columns to look in))
It looks like you formula would be:
=index(BP4:CU32,match(F22,BP4:BP32),match(E22,BP4: CU4))
|