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
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
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
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
