Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions,comp.apps.spreadsheets,microsoft.public.excel.programming,microsoft.public.excel.misc
|
|||
|
|||
Excel Function help needed please!
I have an Excel spreadsheet with several worksheets from which I need
to compare values from several columns in sheet one to a single column in sheet two, and return the value contained within one cell (a "title" at the top of the column)in sheet one to an adjacent cell to the original value cell within sheet two. Can anyone help me to figure this one out? Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions,comp.apps.spreadsheets,microsoft.public.excel.programming,microsoft.public.excel.misc
|
|||
|
|||
Excel Function help needed please!
Hi
try the following: Assumptions: - sheet one has a heading row (row 1) and consists of columns A:F - sheet two has its data stored in column A (starting in row 1) and you want to place the column heading of the matching value from sheet 1 in column B) Enter the following in B1 (on sheet 2): =IF(SUMPRODUCT(MAX(($A$2:$F$1000=B1)*(COLUMN($A$2: $F$1000))))0,INDEX(' sheet1'!$A$1:$F$1,SUMPRODUCT(MAX(($A$2:$F$1000=B1) *(COLUMN($A$2:$F$1000 ))))),"") and copy down -- Regards Frank Kabel Frankfurt, Germany CRWJumper wrote: I have an Excel spreadsheet with several worksheets from which I need to compare values from several columns in sheet one to a single column in sheet two, and return the value contained within one cell (a "title" at the top of the column)in sheet one to an adjacent cell to the original value cell within sheet two. Can anyone help me to figure this one out? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Average Function Help Needed Please! - MoodTool-1.xls (1/1) | Excel Discussion (Misc queries) | |||
Function needed | Excel Worksheet Functions | |||
IF THEN function help needed!! | Excel Worksheet Functions | |||
Help needed with function | Excel Worksheet Functions | |||
Excel Function lessons Needed! | Excel Worksheet Functions |