View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SamB SamB is offline
external usenet poster
 
Posts: 10
Default VLOOKUP function with embedded LEFT

Glenn, this worked as well. I have never seen -- used before. What command
is that giving?

"Glenn" wrote:

cm wrote:
I have duplicated your error; the values in your lookup table in sheet2,
a1.... are numbers; replace your formual as follows:

=VLOOKUP(VALUE(LEFT(F2,3)),Sheet2!A1:B335,2,FALSE)


or this:

=VLOOKUP(--LEFT(F2,3),Sheet2!A1:B335,2,FALSE)