combine several if statements

[JLAJAF]

Hi,
I'm trying to combine several formulas in the attached spreadsheet and am not having any luck. Any help would be greatly appreciated. The order specified of the if statements must remain.

 

[NARAYANK991]

Hi ,

Can you say whether this formula does what you want :

=IF(ISNUMBER(SEARCH("spread",[Category Detail])),
VLOOKUP([Category Detail],BUOBs_Categories[[#All],[Category Detail]:[BUOB]],2,FALSE),
IF([Amount]=0,"",
VLOOKUP([Category Detail],BUOBs_Categories[[#All],[Category Detail]:[BUOB]],2,FALSE)))

Narayan

 

[JLAJAF]

Hi ,

Can you say whether this formula does what you want :

=IF(ISNUMBER(SEARCH("spread",[Category Detail])),
VLOOKUP([Category Detail],BUOBs_Categories[[#All],[Category Detail]:[BUOB]],2,FALSE),
IF([Amount]=0,"",
VLOOKUP([Category Detail],BUOBs_Categories[[#All],[Category Detail]:[BUOB]],2,FALSE)))

Narayan

Yes - that is perfect. This is the first time I'm posting so I very much appreciate you coaching me on how to properly ask the questions. Thank you very much!

 

[JLAJAF]

Am I supposed to mark my question as answered now? I don't see anywhere to do that?

 

[JLAJAF]

May I ask, what does the [#all] do?

 

[NARAYANK991]

Hi ,

These are what are known as structured references ; this is the go to link for these :

https://peltiertech.com/structured-referencing-excel-tables/

Narayan