Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLOOKUP - Tricky problem, help please!
Hello
I have the following formula: =IF(ISERROR(VLOOKUP($A150,'FURL Data'!$C:$G,3,FALSE)),0,(VLOOKUP ($A150,'FURL Data'!$C:$G,3,FALSE))) This was working fine, but for some reason my source data has changed so that the figures I need now span two separate rows, where they were one before. So the above is no longer working as it only finds the first row. Is there an easy way to amend the above, so it finds both rows and adds them together? Would be grateful for any assistance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tricky lookup problem | Excel Discussion (Misc queries) | |||
tricky sum problem | Excel Discussion (Misc queries) | |||
Tricky array problem. | Excel Discussion (Misc queries) | |||
Tricky Excel Problem | Excel Programming | |||
Tricky Excel Problem | Excel Programming |