| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
diferent names
Hello,
I have a list of projects with the different assignments that each one can have. For example: Project Assignemt1 Assignemt2 Assignemt3 A AA A1 ACA B BBB BBo3 BBC C COC C410 CT D D345 d DSi In others sheets I have values for each assignments. And I intend, for example, to make a research for project A that it returns the value that this has in the sheet where it calls A1. Thanks in advance. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
diferent names
Sounds like you need the vlookup( ) function.
-- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "Alexandra Lopes" wrote: Hello, I have a list of projects with the different assignments that each one can have. For example: Project Assignemt1 Assignemt2 Assignemt3 A AA A1 ACA B BBB BBo3 BBC C COC C410 CT D D345 d DSi In others sheets I have values for each assignments. And I intend, for example, to make a research for project A that it returns the value that this has in the sheet where it calls A1. Thanks in advance. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
diferent names
Yes, It does.
Thanks. Gary Brown wrote: Sounds like you need the vlookup( ) function. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Get Data From Diferent Sheets | Excel Discussion (Misc queries) | |||
| Pivot table from diferent worksheets | Excel Discussion (Misc queries) | |||
| HOW DO I ADD AMOUNTS FOR DIFERENT VALUES | Excel Worksheet Functions | |||
| how to select a range that start in diferent row | Excel Discussion (Misc queries) | |||
| Sum values from diferent workbooks | Excel Worksheet Functions | |||
Linear Mode
