| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return a value based on another sheet info
I need to create a formula that returns a value based on the value of another
column. If i enter the name in sheet 2 i need the location and position column to auto fill with correct info. Sheet 1 will be my data base. Sheet 1 Name Location Position Joe Miami Tech Mary New York Manager Frank LA Client Sheet 2 Name : Location : Position: |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return info based on 1 criteria | Excel Discussion (Misc queries) | |||
| Enter info in one sheet, auto enter in another based on one field | New Users to Excel | |||
| varying validation info based on preceding info | Excel Discussion (Misc queries) | |||
| Return info based on Date Range | Excel Worksheet Functions | |||
| Set color of cell based on info on another sheet? | Excel Worksheet Functions | |||
Threaded Mode
