nested lookup function in numbers

Question

nested lookup function in numbers

I need to use a nested lookup function but I haven't been able to get it working. I'm currently using nested IF statements but as the tables get bigger they've become unwieldy. I'm trying to use these two tables but there are others. On Points Column B & C are Pop-Up Menus with the Tanks listed in "B" and the Number of tanks in "C". Want to get the numbers I need from the Headquarters, Core and Support tables as this would make it easier when adding new units to these tables.

Mac mini (M2 Pro, 2023)

Posted on Oct 27, 2024 2:46 PM

Reply

Answer 1

SGIII

Level 8

36,026 points

Oct 27, 2024 8:12 PM in response to franks4business

I am not sure exactly what you want to do but in general you want to avoid nested ifs if you can.

Very like you want to consider using:

XLOOKUP - Apple Support

and possibly:

IFS - Apple Support

In general you will find life much easier (much simpler formulas) if you combine the data you are looking up into one table. Consider combining the three tables and adding a column the indicates Headquarters vs Core vs Support.

SG

Reply