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 Look up in a list of the same text

I have a sheet of a list of customers. The list has the same customers in
many times not just once.

I am trying to find the customers name in the sheet, then tell me what the
information is in the next column, just like in VLOOKUP.

However, once it has given one piece of information, I then need it to look
further down the same column, and find the customers name again, and give me
the information in the next column...and so on...and so on...

Can anybody help or can Excel not do this?

If it can't, can anybody suggest a program that can.
 
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
Excell Dropdown List. Display alternate text than found in list. Shawnn Excel Discussion (Misc queries) 14 December 11th 08 07:43 PM
How to sort a list of text? Eric Excel Discussion (Misc queries) 8 May 14th 08 06:40 PM
text from column to a list kraway Excel Discussion (Misc queries) 2 March 28th 07 06:39 AM
Text retrieve in a list-like WS yadaaa New Users to Excel 2 June 6th 06 10:42 AM
List box to Text Box mully Excel Discussion (Misc queries) 4 August 8th 05 03:28 PM


All times are GMT +1. The time now is 06:20 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"