Look up in a list of the same text

[Warren9533]

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.

 

[N harkawat]

Say your list in from A1:b10 and the value you are looking up is in D1
=INDEX($B$1:$B$10,SMALL(IF($A$1:$A$10=$D$1,ROW(A$1:$A$10)),ROW(1:1))
(after copying press ctrl+shift +enter)
and copy the formula down
Mask this formual with if(Iserror ...if needed

 

[Ashish Mathur]

Hi,

You may want to refer to this link

http://office.microsoft.com/en-ca/excel/HA012260381033.aspx

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Herbert Seidenberg]

Excel 2007
Transpose flagged Table row items into column items.
http://www.mediafire.com/file/x5tkjltnmyd/03_28_09a.xlsx

 

[Bernd P]

Hello,

I suggest to use my UDF Cfreq:
http://www.sulprobil.com/html/cfreq.html

Regards,
Bernd

 

[Herbert Seidenberg]

Excel 2007
Incorporated Bernd's UDF
in my previous example.
http://www.mediafire.com/file/ztnz2ttzjw2/03_28_09a.xlsm