Hi there, thanks in advance for any help I receive.

I'm wanting to use a function, such as maybe VLOOKUP (in the yellow cells on my data page). to check on the data sheet column BJ (which is my dataset column),



then lookup on the dataset page in the full BLUE COLUMN A for either matching text in Column A as DATA Column BJ and copy the forumula into the cell.

e.g on the data page, CELL b2 needs to lookup BJ2 and read the text thats in this column (or blank value), then lookup on the blue column on dataset sheet for matching text (or default to set of formulas for a blank value) the formulas i want to copy are in the orange cells.

when the dataset has no value / is blank then i want it either defaulting to the cell with the blank value. or MD Lookup Table . as md lookup table is not a dataset but the actual main table for all the data that has no values in the dataset column.


i tried to achive it with VLOOKUP but got REFS