| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match - not sure how to use this function
I have created a Validation List called Suppliers, and then once I have
picked a supplier I want it to pull over the correct Account Code. An example of the list I have is: A1 B1 1 Fred Bloggs C0011 2 Snoopy C0022 3 Donald Duck C0033 4 Mickey Mouse C0044 5 Pluto C0055 6 Danger Mouse C0066 So when I pick from the drop down list (which is on another sheet) Fred Bloggs, I want it to pull over the code C0011 in a separate cell. Not sure if I have made this clear or not, but any help will be appreciated. I tried a nested if function but it wouldn't allow me too many nested functions. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find the second match using the match function | Excel Worksheet Functions | |||
| how can we get unique values in match function for same match key. | Excel Worksheet Functions | |||
| index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
| Match as well as does not match array function | Excel Discussion (Misc queries) | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Threaded Mode
