| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with excel Formula
What I am trying to do is:
SheetA has names in column D Sheet B has the same names in column B but different order I want it to match the names in sheet A column D and sheet B column B and return the numer from column I Is this possible and if so what is the formula? Thanks!!!! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help with excel Formula
=vlookup(SheetA!D1,SheetB!$B;$I,8,0)
depending on what sheet column I is in "Emma" wrote: What I am trying to do is: SheetA has names in column D Sheet B has the same names in column B but different order I want it to match the names in sheet A column D and sheet B column B and return the numer from column I Is this possible and if so what is the formula? Thanks!!!! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help with excel Formula
"bj" wrote: =vlookup(SheetA!D1,SheetB!$B;$I,8,0) depending on what sheet column I is in "Emma" wrote: What I am trying to do is: SheetA has names in column D Sheet B has the same names in column B but different order I want it to match the names in sheet A column D and sheet B column B and return the numer from column I Is this possible and if so what is the formula? Thanks!!!! Ok I still can't get it to work. Here are the sheet names Look for Names in "FRI 4D" column D Match to names in "4dAverage" column B Return number from "FRI 4D" column I to column D in 4d Average shhet thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
| Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
| Excel Formula Doesn't Execute (Shows formula-not the calcuation) | Excel Discussion (Misc queries) | |||
| Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
| Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) | |||
Linear Mode
