| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
H and V lookup or match?
If I have the following data
A B C D E NY MO IL NJ KS 1 Jim x x x 2 Joe x x x x 3 Amy x x x 4 Jane x x x x How can I write a function that if I input NY into F1 the answer "Jim, Joe, Jane" will show up in G1 and also if nothing is in F1 is will be blank? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I lookup when match has more than one value? | Excel Worksheet Functions | |||
| Lookup Formula: Return 1st match, then 2nd match, then 3rd match | Excel Discussion (Misc queries) | |||
| Lookup? Match? pulling rows from one spreadsheet to match a text f | Excel Worksheet Functions | |||
| Lookup Match | Excel Worksheet Functions | |||
| Lookup & match | Excel Discussion (Misc queries) | |||
Threaded Mode
