Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula problem
Hello from Steved
=INDEX(ParadoxBusType!I:I,MATCH($A6,ParadoxBusType !$K:$K,0)) Ok the above formula at cell A6, then looks in Col I:I in ParadoxBusType! worksheet once found looks in K:K for the value, it is not working please what have I overlooked. the formula is in Cell D6. The above is in the same folder instead of sheet1 I've named it ParadoxBusType!. Thankyou for taking time on my problem. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula problem on network | Excel Discussion (Misc queries) | |||
problem with Array Formula | Excel Worksheet Functions | |||
Problem with formula | Excel Discussion (Misc queries) | |||
Named SUM Formula with relative refernce(s) | Excel Worksheet Functions | |||
Need a formula for this problem | Excel Worksheet Functions |