Microsoft Office Forums - View Single Post - Using IF and VLOOKUP

Thread: Using IF and VLOOKUP

View Single Post

Old

11-20-2013, 12:35 AM

excelledsoftware excelledsoftware is offline

excelledsoftware is offline

excelledsoftware uses Windows 7 64bit

Windows 7 64bit excelledsoftware uses Office 2003

excelledsoftware uses Office 2003

Office 2003

IT Specialist

Join Date: Jan 2012

Location: Utah

Posts: 455

excelledsoftware will become famous soon enough

Default

Have you tried the If(iserror formula like so

Code:

=IF(ISERROR(VLOOKUP(B5,'Product List'!$A$8:$D$119,2,FALSE)),"Product ID Not Found",(VLOOKUP(B5,'Product List'!$A$8:$D$119,2,FALSE)))

Reply With Quote