I have set p the following formula below that where the result is #N/A , then to display "Sold"
I would like to amend the formula that where the result is not #N/A then to show blank, otherwise if #N/a then show Sold
![]()
=IFERROR(VLOOKUP(A2,'[Stock Numbers.xlsx]Sheet1'!$A:$A,1,FALSE),"Sold")
your assistance in resolving this is most appreciated
Bookmarks