Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I'm sure this is easy but I can't hink right now...its Friday. I just wanted
to do a nested IF, INDEX, MATCH. So that if the INDEX/MATCH = 0, it does another one. SO here is the formula: =INDEX('Sheet2!'$E$4:$E$3429,MATCH(Sheet1!C4,'Reta il LCR'!$B$4:$B$3429,FALSE)) Basically if this ends up being 0, then I want it to do another INDEX/MATCH. ANy thought? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find value in array | Excel Worksheet Functions | |||
Is it possible? | Excel Worksheet Functions | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Negative numbers in easy formula getting me down... | Excel Discussion (Misc queries) | |||
Easy formula, but need help please | Excel Worksheet Functions |