98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Vlookups on formulas
Vlookups on formulas
Resolved · Low Priority · Version 2003
Fri 29 Jan 2010, 10:57Delegate Christina said...
Christina has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Vlookups on formulas
Hello,
I have done the following formula =LEFT(B17,3), and then I want to do a Vlookup on the results of the above formula to then pull through the corresponding results. For some reason the results come through as #N/A.
Kind regards,
C Christoforou
Fri 29 Jan 2010, 16:40Trainer Simon said...
RE: Vlookups on formulas
Hi Christina,
Thank you for your question.
Can you please tell me what the data is in cell B17.
I assume you are trying to take the first three letters from the text like a country code(Aus).
Is the result of the left formula returning correctly? If so are you using the result as your Lookup Value? When you create a Vlookup formula your Lookup Value must be the value that is contained in the first column of your data.
Let me know if this works.
Regards
Simon
Fri 29 Jan 2010, 16:45Delegate Christina said...
RE: Vlookups on formulas
Hi Simon,
Thank you for your quick response. Cell B17 contains "213 London" therefore I am extracting just "213" which comes through correctly. My vlookup table array has 2 columns:
1st being the column with 213 in it
2nd being a corresponding code number eg: 6
Kind regards,
Christina
Fri 29 Jan 2010, 16:58Trainer Simon said...
RE: Vlookups on formulas
Hi Christina,
Thank you for your response.
If your 213 was in cell A1 and the 6 in cell B1 and in cell C1 you type the value you are looking for in the table, then does your formula reflect the one below:
=vlookup(C1,A1:B1,2,FALSE)
Have a good weekend.
Regards
Simon
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Shortcut keys to move between sheetsInstead of clicking on a sheet tab to view a sheet, use the following keyboard shortcuts to move between sheets in the same file: |
