how to vlookup of one cell by starting 2 digits of another cell?
in [Functions]
|
Prev: How do I get the MSNStockQuote function in Excel?
Next: In excell 2003, increasing number of items shown in drop down list
From: Uday on 9 Feb 2010 23:50 how to vlookup of one cell by starting 2 digits of number in another cell?
From: Fred Smith on 9 Feb 2010 23:58
Something like: =vlookup(left(a1,2),B:G,2,false) Regards, Fred "Uday" <Uday(a)discussions.microsoft.com> wrote in message news:DA6A96DB-4214-4563-B1B2-052EDC54A57E(a)microsoft.com... > how to vlookup of one cell by starting 2 digits of number in another cell? |