View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Manish Seth Manish Seth is offline
external usenet poster
 
Posts: 1
Default Lookup data in the list

Hi All,
I have a list as shown bellow, I want to pick up the date correcponding to
the value on cell A1 and the value in B2 or B3. So it is some thing like this
=Vlookup(a2,a:b[b2+1] or[b+2] {this is just a vierd example}
ColumnA ColumnB
ID Name
1 12082A IN-tuition
2 Ms. Gayle
3 Gayle Theresa
4 Sofiane
5 12082B tuition
6 Ms. Gayle
7 12298A Language Institute
8 Senouci Bereksi
9 AOUL
10 Bereksi


Kindly Help ASAP, As I am Stuck in my assignment.