Full Version: how to do LOOKUP without getting "#N/A" results
UtterAccess Discussion Forums > Microsoft® Office > Microsoft Excel
pcaling
Hello,
I have two worksheets, 1 tab and 2nd tab. The 1st tab contains the list of zip codes(A column) and 2nd tab has the list of employees with their zip codes(zip code is in B column). I added a second column(B col) to the 1 tab with a value of '1' to all zip codes. On the 2nd tab, I have a formula "If( vlookup(b1,1st tab,2, false)=1, "eligible", "not eligible"). The problem is when a zip code is not listed in the 1st tab, it is giving me a result of "#N/A", which is right since the zip code from the 2nd tab is not listed in the 1st tab.
What I want or trying to do is, if zip code from the 2nd tab is not listed in the 1st tab, it will display in the 2nd tab across the zip code "not eligible". If listed will display'eligible".
Thanks in advance,
Pedro
dannyseager
try
If(IsNA(vlookup(b1,1st tab,2, false)),"not eligible","eligible")
pcaling
Thanks Danny for the help! Now my spreadsheet is working properly...
edro
dannyseager
glad to help
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.