If two cells are blank then return blank, else vlookup cell with populated data

you cannot test more than one cell with ISBLANK at once. So either:

Formula:

=IF(AND(ISBLANK(D4),ISBLANK(D5))," ",IFERROR((IF(ISBLANK(D4),VLOOKUP(D5,'Master List'!B:O,14,0),VLOOKUP(D5,'Master List'!D:O,12,0))),"Not TSRd"))

or, instead of testing ISBLANK, just count non-blank cells, like:

Formula:

=IF(COUNTA(D4:F5)=0," ",IFERROR((IF(ISBLANK(D4),VLOOKUP(D5,'Master List'!B:O,14,0),VLOOKUP(D5,'Master List'!D:O,12,0))),"Not TSRd"))

PS. I'd rather use empty string "" than a space " " when there is no input, but of course this is to some extend personal taste (and also how - if at all - the output cell is further processed)

Hi -

I think your problem may be that ISBLANK is not a function that normally accepts arrays (D4:D5) as an argument. You can either make this an array formula by pressing Ctrl-Shift-Enter from the formula editing window to engage the array functionality. If you did it correctly, Excel will add curly braces {} to the formula. You will also have to unmerge the cells you are referencing (D4 and D5 are both merged across D, E, and F) and you will have to unmerge the cell the formula is in.

Just as a general practice, try not to reference merged cells from a formula. The results are sometimes unpredictable and you can spend a long time trying to figure out why it's not working when the answer is simply because you are referencing merged cells.

Hop this helps.