Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Look up in a list of the same text
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 "Warren9533" wrote: 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Look up in a list of the same text
Hi,
You may want to refer to this link http://office.microsoft.com/en-ca/ex...260381033.aspx -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Warren9533" wrote in message ... 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Look up in a list of the same text
Excel 2007
Transpose flagged Table row items into column items. http://www.mediafire.com/file/x5tkjl...03_28_09a.xlsx |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Look up in a list of the same text
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Look up in a list of the same text
Excel 2007
Incorporated Bernd's UDF in my previous example. http://www.mediafire.com/file/ztnz2t...03_28_09a.xlsm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excell Dropdown List. Display alternate text than found in list. | Excel Discussion (Misc queries) | |||
How to sort a list of text? | Excel Discussion (Misc queries) | |||
text from column to a list | Excel Discussion (Misc queries) | |||
Text retrieve in a list-like WS | New Users to Excel | |||
List box to Text Box | Excel Discussion (Misc queries) |