Need VLOOKUP to return zero or blank if not match
I have the following VLOOKUP formula copied down through an inventory spreadsheet: =VLOOKUP(Sheet1!B2,Sheet2!$A$2:$B$600,2,FALSE)
The issue is that sheet two, column A is a subset of sheet 1, column B that varies day to day. The #NA result if there is not a current match is causing problems for the end user.
How do I modify this so that it returns the current values if a match exists, but returns a blank cell or a zero if there in no match?
Thanks.
Hi climbmda,
If you upgrade to a newer version of Excel the function will be available. You can still do it in 2003 but it is just harder. See
http://www.excelfunctions.net/Excel-Iferror.html
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
perhaps..
=IF(ISNA(VLOOKUP(Sheet1!B2,Sheet2!$A$2:$B$600,2,FALSE)),"",VLOOKUP(Sheet1!B2,Sheet2!$A$2:$B$600,2,FALSE))
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks