vlookup reference

Can the Lookup_Value (in vlookup) be a reference to a cell that has a seperate function in it. If so how does the string need to be wordered.

Example: =VLOOKUP(C6,K5:L200,2,FALSE)


Where C6 is coded with this function: =LEFT(C15,4)


Thanks,
Justin

What do you have in C15?

You might need to know that LEFT function always returns a text value, so if C15 contains a number, 123456 then LEFT(C15,4) returns a text string "1234" which VLOOKUP won't match with a number 1234.

If that is the case and C15 is always numeric you might need to convert to a value by using

=LEFT(C15,4)+0

DaddyLongLegs, I am always amazed with you, you are an excel God!! That worked perfect. Thank you again for the time and help with my issue. I have been pondering it for days, I just couldn't figure out that +0, since it is a number.

Thanks,
Justin