Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup to bring back multiple values
Hi,
I have a sheet with various names in column A with attributes in col B, the names can occur more than once. a normal vlookup will only bring back the first value in col B which i know. but i want to bring back all the different result in column b for a name which occurs more than once. I know this invloves Arrays, but the eg ive seen is set up in a way where the name you are looking is on the first line, and amending it does not really work for me. Does anyone have any suggestion or a better example of how to do this? hope ive made this clear!!! Cheers |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Bring Back DBF! The GIS Industry uses it! | Excel Discussion (Misc queries) | |||
Bring back .dbf in Excel | Excel Discussion (Misc queries) | |||
Bring back lowercase values | Excel Worksheet Functions | |||
Bring Back Qualified Sum from another WB | Excel Worksheet Functions | |||
Bring back the old help format! | Excel Worksheet Functions |