Hello,
I am attempting to have a vlookup show a value from a list.
In theory, the top three rows will show a person name that matches the coresponding value from colum E.
I have searched, and everything states this formula should work.
=VLOOKUP(B2,B10:E24,1,FALSE)
I am using 2013 for this workbook.
thanks
Kent
I believe you want your formulas to be
Formula:
Please Login or Register to view this content.
and
Formula:Please Login or Register to view this content.
Dave
Try this in C2 and fill down:- MooFormula:Please Login or Register to view this content.
I am unable to open the attachment in Excel 2010. Despite the "xlsx" extension (or because of it!), Excel complains that the file content is unreadable. On a whim, I tried changing the extension to "xls", "xlsm" and "xlsb", to no avail.
So please remove and re-attach a valid Excel file.
-----
Aside.... I suspect that your title is misleading.
If =VLOOKUP(...) is recognized as a formula, it always returns a value; just perhaps not what you expect. Even #N/A is "a value".
So, please explain the value (result) that the formula does return.
On the other hand, if the cell displays "=VLOOKUP(B2,B10:E24,1,FALSE)" literally, please state that more clearly. That might be a problem with the cell format (Text once, if not now).
-----
Another observation.... =VLOOKUP(B2,B10:E24,1,FALSE) either returns the value in B2 (if it matches a value in B10:B24) or #N/A (if it does not match a value in B10:B24).
I'm not clear on how that relates to the fact that: ``the top three rows will show a person name that matches the coresponding value from colum E``.
In other words, you might not have designed the VLOOKUP expression correctly, in the first place.
I wonder if that is what you mean by it is ``not returning a value``.
If you need help with the formula design, please provide the values of the referenced cells. If they are calculated, please show the values with 15 significant digits (which might be different from 15 decimal places).
Last edited by joeu2004; 09-27-2019 at 07:08 PM.
I got a message saying the file was corrupt and was offered the option of Excel repairing the file. It seemed to work but that's on Office 365.
Here's the repaired copy with the formulas I used. The OP's formulas were
=VLOOKUP(B2,B10:E24,1,FALSE)
and
=VLOOKUP(F2,B10:E24,1,FALSE)
Last edited by FlameRetired; 09-27-2019 at 07:20 PM.
Moo the Dog, that worked.
I was attempting to get the Name to be displayed.
I apologize stating no value was returned. I had the spreadsheet set to blank NA values. So it was not showing anything until I changed the fill color to display the NA.
I appreciate everyone taking the time to help.
Kent
Thanks. I was just in the process of PMing you. I, too, was offered the option to "recover" the file. I never trust Excel to do that well. But after seeing your response, I tried it. Excel indicates that it removed some content. But I guess there is enough there.Originally Posted by FlameRetired
You seem to be on top of it. So I'll step back.
(The OP explains why I could not see the #N/A error until I clear formats.)
Glad to help.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. And if you feel like leaving some rep points for anyone who helped, feel free to click on the * Add Reputation * link on a post of the person who helped! Thanks.
- Moo
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks