Help Please!!
I am working on a Product List and have managed to Achieve most of what I need but on Cells which have not been completed the Formula is returning a #N/A Message, is it possible to modify the formula to display a Blank.
my formula is as follows:
=IFERROR(VLOOKUP(D53,'Product List'!B:C,2,0),IFERROR(VLOOKUP(D53,'Product List'!D:E,2,0),VLOOKUP(D53,'Product List'!F:G,2,0)))
I can add my File if this helps.
Thank you in anticipation
David Farley
Bookmarks