Thread: [Solved] vlookup nested formula
View Single Post
 
Old 09-13-2018, 08:39 AM
paxon paxon is offline Windows XP Office 2007
Novice
  
Join Date: Feb 2016
Posts: 13
paxon is on a distinguished road
Default vlookup nested formula
How can I tell the vlookup, if the vlook up ISNA give me "0", if is = to cell"A1" give me YES else NO (as per sheet1)

I would like to see in
cell B 2 -4 yes
cell B3 no.

Thanks
Attached Files
File Type: xlsx Supplier.xlsx (52.6 KB, 11 views)
Reply With Quote