Index Match (?) to two different sheets (unique values)
Hi - I am not sure what is the correct formula to use - I have tried a few and I get errors, so would appreciate some assistance. I have been using Cell Linking to pull in the data, but due to the volume it has become cumbersome and unreliable.
I have a master project plan with unique Site IDs in the primary column, and the site details are split between two client sheets - one for each brand; also using the same unique Site IDs in the primary columns. The client sheets are very large, so when trying to select a range, I receive an error that I have exceeded the range limits if the columns are too far apart.
I need the right formula to look up and return the information from either sheet - like a VLOOKUP but returning the data from one of two places.
Example: Site ID 12345 (primary column) I need the activation date to pull in from either brand A or brand B, however on the brand A sheet the activation date is column 5 and on brand B it is column 15.
What is the best type of formula to use?
Help Article Resources
Check out the Formula Handbook template!