I am using this formula:
=VLOOKUP(A2,'Database 1'!A:B,2,FALSE)
What it is doing is checking to see if the number in cell A2 matches any of the numbers on another worksheet within the same workbook, and if so, displaying the text in that cell. If there are no matches, it displays #N/A. I would rather it be blank if possible. Any ideas?
For Excel 2007 and beyond you can wrap your formula in an IFERROR to suppress error results.
=IFERROR(VLOOKUP(A2,'Database 1'!A:B,2,FALSE), "")
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
That worked perfectly, Thank You
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks