I am working on a master sheet that contains data from 2 separate sheets (Say SheetA and SheetB). I need to run VLOOKUP functions on the master sheet in order to pull some information in from a fourth sheet.
Here is essentially the question I am asking: : IF my data came from SheetA, THEN run this VLOOKUP, IF my data came from SheetB THEN run this VLOOKUP.
My problem is that depending on where my data came from (either SheetA or SheetB) I will run different VLOOKUPs against it. For instance In column G I only want to run a VLOOKUP if the data came from SheetA, but in column H I want to run a different VLOOKUP if the data came from SheetB. Right now when I drag my VLOOKUP over data coming from a source not referenced in the VLOOKUP I get #REF errors and Instead of those #REF errors I would like to just see the cells as blank.
Essentially I would just like to enter these formulas once at the top of my master sheet so they can be dragged down the length of the sheet and properly render regardless of where the data came from.
Bookmarks