| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return value based on another vlaue
I am trying to search a list of names (1200 names) for an exact match then
return back a department number. For instance if John Doe works in Dept. 10. I want to type in "John Doe" on my list in tab 1 and the next cell with this formulas will search the list of names and return "10". Please help! Thank you! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Return value based on another vlaue
Look in help for Vlookup.
Regards, Fred. "Jesse" wrote in message ... I am trying to search a list of names (1200 names) for an exact match then return back a department number. For instance if John Doe works in Dept. 10. I want to type in "John Doe" on my list in tab 1 and the next cell with this formulas will search the list of names and return "10". Please help! Thank you! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| return value based on another value | Excel Discussion (Misc queries) | |||
| hi, how to display my text vlaue in Axis (ex: J, F, M, A....) | Excel Discussion (Misc queries) | |||
| URGENT! how count how often a vlaue occurs within a range of value | Excel Worksheet Functions | |||
| Fixed vlaue in the Fill handle opperation | Excel Discussion (Misc queries) | |||
| #vlaue! | New Users to Excel | |||
Linear Mode
