Hello, a few of you helped me to get this worksheet up and running a few days ago. I used the VLOOKUP solution but for some reason it is good on the smaller units but on the larger ones, I get an #NA error.
I have used online help, but that doesn't even go close to solving this. Please look at the attached photo snip of the worksheet, and tell me if you see what I'm doing wrong.
All assistance is very much appreciated.VLOOKUP #NA error.PNG
not every1 can open .png files, myself included. It would be far better if you could upload a sample of your file, showing what you have, and an example of your expected outcome. Thanks
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Need to use absolute reference for Table Array like this $Q$17:$R$21
With that formula you are looking for an exact match in your table (set by having the fourth parameter of 0 or FALSE). The value you are looking up does not exist in your table, so you get the error #N/A returned instead. To avoid this you could have something like:
=IFERROR( your_vlookup_formula ,"Not Found")
which will give you that error message instead.
Hope this helps.
Pete
This is the jpg, excel vlookup error.jpgOriginally Posted by FDibbins
not every1 can open .png files, myself included. It would be far better if you could upload a sample of your file, showing what you have, and an example of your expected outcome. Thanks
Hope this is easier to open
@ Geof, what Fdibbins mean iss could you provide the real workbook XLS file.
with regards to your error #N/A
in excel 2003 w/c your profile show
=IF(ISERROR(VLOOKUP(.....)),"not found",VLOOKUP(.......))
or =if(isna(...... same above syntax
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Yep, now done that, but the error is still there. Note, it is only on the highest value where this error occurs. Leading me to suspect that it may have something to do with the nut behind the keyboard
Did you not read my post? It's because you do not have an exact match in your table.
Pete
maybe it is supposed to look from column M,N not Q,R coz i don't see 80-110 in column Q i see it at column M as stated by Pete
Geoff,
Look at the value you have in cells E20:22 and check that against the value in cell Q37.
See the problem?
Last edited by Steve N.; 11-20-2012 at 09:48 PM.
Yes, a case of cubicle dyslexia. My error, and hope I didn't waste too much time
If I had a nickle for every time I overlooked something in a formula I'd be sending this from my vacation home on Oahu.
And props to Pete for catching the 'exact match' issue.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks