I'm at a loss. When I try to use VLOOKUP, I select the Lookup Value but it won't capture the Table Array that I'm trying to highlight. There is no error. It just won't do anything.
I'm at a loss. When I try to use VLOOKUP, I select the Lookup Value but it won't capture the Table Array that I'm trying to highlight. There is no error. It just won't do anything.
How does it appear when viewing the cell (looking at the spreadsheet with the cell not active)? Is the formula text within the cell? or does the cell look blank? (Seeing your spreadsheet would help, Go Advanced>Manage Attachments)
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Can you attach a file showing the error?
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.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Does it work if you type it in manually?
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
It doesn't appear to let me attach a file. I went to Go Advanced and clicked on the paper clip and it doesn't do anything.
Use "Go Advanced" then "Manage Attachments" (Paper Clip icon now appears to be defunct!)
The paper clip doesn't work at the moment. Use Manage Attachments, then Browse, navigate to and double-click on your file, then Upload | Close this Window | Submit post.
Hope this helps.
Pete
OK attachment added.
Forgot to say that I'm trying to do a lookup in Column M.
I can see no VLOOKUP formula. What formula are you trying to enter and exactly where?
Okay, where is your lookup value, what is the table you are using, how many columns offset, are you looking for an exact match etc.?
Please help us to help you.
Pete
My lookup value is in column L and my table array to lookup against is one column. Yes exact match on the lookup.
What are:
1. The lookup value - which cell in column L?
2. The lookup array (give cell references such as L2:M30).
3. The column in the lookup array where the result should be found (e.g. 1, 2, 3, etc.)
Column L looks exactly the same as column J and column K.
What is it that you are trying to do?
Pete
OK pick any value in Column L - I need it for every line.
Lookup is against a separate file and it's the one column I'm trying to select. There has to be something wrong in the file I attached, not the file I'm trying to look up against because I just did a VLOOKUP against that file using another file and it worked.
But we can't test it without the file you are looking up against, can we? So attach that, too, please, and explain clearly, step-by-step, what you are doing.
can you explain exactly what you are trying to do here? What are you trying to find and what would a sample answer look like?
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
I think OP is talking about the actual physical motions of creating a formula (any formula, not just vlookup)
When you type = then click on another sheet to select a range, it builds the formula.
That is what I think OP is saying isn't working.
That is probably caused by the 'other book' not being opened in the same instance of Excel which you are entering the formula in.
Make sure you open workbook A first.
From within workbook A, go to File - Open, browse to and open workbook B
Now you can build formalas between the 2 books as normally expected.
I know they are the same. However Column L is formatted as General, not text or number, etc. I have this spreadsheet with the material numbers from a legacy system. I have another spreadsheet with the legacy numbers and their new production system numbers. I'm just trying to pull in the new production system numbers.
Read Jonmo's post above yours - does it answer the query? If not, attach the second workbook here.
YES!! This solved it. It's working now. I can actually insert a formula. Many thanks!
Glad you are sorted!
You're welcome.
I find it fascinating how 3-4 people can read the exact same thing, and all can come away with a different interpretation of what was said - and sometimes none get what was actually meant...until someone does read it the way it was meany, and then we all get it
All part of the spice of life, Ford.
It helps to be an X-Man with mind reading powers
Just, wow! Kudos to you, Jonmo.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks