Hi all,
I am trying to write a formula that uses data from a table, however there are multiple tables, and the correct one to be used is based on what is entered in a specific cell. I have attached the example worksheet - I have the basic formula in cell D28, and my attempt at a more complex version in cell D32, but I don't know how to extend it to cover all four different data tables without using a load of IF functions. Maybe some sort of LOOKUP function? Any help would be appreciated.
Thanks,
Ruth
Bookmarks