Index formula - add multiple tables to formula

[bellina03]

Hi everyone

I'm new to using the Index formula and was hoping for some assistance.

A very kind person on this forum assisted me recently with creating this formula to solve a problem. It was fantastic and worked as it needed to.
=INDEX(Table2[#All],MATCH($E2,Table2[[#All],[Full name]],0),MATCH(B$1,Table2[#Headers],0))

I now have an additional 2 tables that I need to add to this formula but don't know how to add them in order to make the Index formula work.

I have:
Table2 (this is the original table in the above formula)
Table3NET - additional table I need to include
Table4APAC - additional table I need to include

Hoping someone can help me out.

Thanks and have a great day

[Green Crocodile]

Hi,

When you say you would like more tables to the formula what exactly do you mean? Do you want excel to check table2, then if cannot find a value check table3net, then if still cannot find value move on to the next one?

[FDibbins]

Where these tables located in relation to the 1st table?
What data do all these tables contain?

[bellina03]

Hi Green Crocodile

Yes this is exactly what I need it to do. Every table is located in a different worksheet all in the one workbook

[Green Crocodile]

Something like this should work.

Please Login or Register  to view this content.