Thread: Lookup help!!
View Single Post
  #5   Report Post  
scott45
 
Posts: n/a
Default 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))