Thread: how to vlookup of one cell by starting 2 digits of another cell?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
  
Posts: 2,389
Default how to vlookup of one cell by starting 2 digits of another cell?
Something like:
=vlookup(left(a1,2),B:G,2,false)

Regards,
Fred

"Uday" wrote in message
...
how to vlookup of one cell by starting 2 digits of number in another cell?

Reply With QuoteReply With Quote