ExcelBanter - how to vlookup of one cell by starting 2 digits of another cell?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how to vlookup of one cell by starting 2 digits of another cell? (https://www.excelbanter.com/excel-worksheet-functions/255865-how-vlookup-one-cell-starting-2-digits-another-cell.html)

Uday

how to vlookup of one cell by starting 2 digits of another cell?

how to vlookup of one cell by starting 2 digits of number in another cell?

Fred Smith[_4_]

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?

All times are GMT +1. The time now is 02:48 PM.