| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lists / Menus
.. I have a drop down list (that looks at another worksheet)
and I select their first name, I then want another cell to automatically bring up that persons surname.. A formulated col using say, index/match would do that for you Eg In Sheet1, if DVs in A2 down, you could have something like this in B2 down: =IF(A2="","",INDEX(Sheet2!A:A,MATCH(A2,Sheet2!B:B, 0))) where cols A and B in Sheet2 holds the surnames & firstnames -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| difference between word 2003 menus and word 2007 menus-Explain pl | Excel Discussion (Misc queries) | |||
| Adding sub-menus and actions to data in drop down lists in Excel 2 | Excel Worksheet Functions | |||
| width of drop-down menus in lists | Excel Worksheet Functions | |||
| Drop-Down Menus in Created Lists | Excel Worksheet Functions | |||
| New Menus - attaching but menus are reset | Excel Worksheet Functions | |||
Threaded Mode
