LinkBack URL
About LinkBacks
I am having an issue with my LOOKUP function and I am not quite sure what is going on. Some cells have N/A and others have a zero. ANy help you can give me would be GREATLY appreciated. I hope my excel file is attached...? Thank you.
I am having an issue with my LOOKUP function and I am not quite sure what is going on. Some cells have N/A and others have a zero. ANy help you can give me would be GREATLY appreciated. I hope my excel file is attached...? Thank you.
Select B2:B5. Do you see the green triangles? They are warning you that something is wrong. Click on the yellow diamond/white bacjground. It tells you that the numbers are stored as text. Select convert to number.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Alternatively, use this formula fix:
=LOOKUP($Q2,VALUE(B$2:$B$6),C$2:C$6)
In future, please use more descriptive thread titles (see our rules). Thanks.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Mmm. It is an alternative. However, IMHO not an especially good one. If you let your data become riddled with improperly stored values, the problems will just get worse and worse...
Agreed, Glenn, however sometimes it's a case of not being able to control the format in which data 'lands' in the workbook, so knowing the workarounds can be useful.
Can you explain yours a little more to me Ali? That does not look like the way my mind thinks, but I always like to learn something new. Thanks Ali.
Thanks Glenn! This spreadsheet is from my previous working spreadsheet. I had to use TEXT instead of numbers because one of my numbers is a double zero (00). In number formatting it converts it to a single 0 so that is why I was using text.
The other thing that doesn't make sense to me is that the other spreadsheet was working. All I did was delete 31 rows below it and then it stopped functioning correctly. Thanks again for your help Glenn!
So... are you OK with things now, or do you need some more help with this? If so... shout.
if not, then you're welcome.
If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.
It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks