Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hello,
I have some sheets the same book. One is the GLOBAL, and the others are the names of collaborators. In the GLOBAL one I have a list with the same names of the collaborators. I want that in the sheet of each collaborator appears informations that are in the GLOBAL. The function vlookup doesn't work, because the names of the list of the GLOBAL one can be sorted and it position is modified and because the names of the collaborators are not in the sheet of each one. What I intend is a function that looks for the name of the sheet that is equal to the name of the list of the GLOBAL one. Thanks in advanced. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
excel sheet bootom half sheet goes behind top part of sheet | Excel Worksheet Functions | |||
Duplicate sheet, autonumber sheet, record data on another sheet | Excel Worksheet Functions | |||
"='sheet 1'!D4" auto fill sheet to sheet ='sheet 2'!D4 | Excel Worksheet Functions | |||
How do I select price from sheet.b where sheet.a part no = sheet.b | Excel Worksheet Functions | |||
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) |