Home |
Search |
Today's Posts |
#4
![]() |
|||
|
|||
![]()
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)) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Another way to lookup data | Excel Worksheet Functions | |||
Lookup Vector > Lookup Value | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Lookup function w/Text and Year | Excel Worksheet Functions | |||
double lookup, nest, or macro? | Excel Worksheet Functions |