Thread: Lookup help!!
View Single Post
  #2   Report Post  
mbarron
 
Posts: n/a
Default Lookup help!!

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))