LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Lookup and average data in an unsorted list James A Excel Worksheet Functions 1 July 30th 09 04:06 AM
Return a list of data, rather than just one value for a lookup Drew Excel Discussion (Misc queries) 1 May 19th 06 11:59 PM
lookup? list data into summary table Joe Excel Worksheet Functions 6 December 22nd 05 12:25 AM
Lookup with two variable data list cells Monkey Excel Worksheet Functions 2 February 10th 05 11:29 PM
Lookup values in a list and return multiple rows of data Amanda L Excel Worksheet Functions 2 December 2nd 04 04:48 PM


All times are GMT +1. The time now is 06:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"