Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Getting a value from large table.
Hi, I have a data table where column A = Make (named MAKE), B = Model (named
MODEL), Row 1 = Model Year (named MODELYR). On a different sheet, I have a list of miscellaneous combinations. On this sheet, column A contains the make, B the Model and C the Model Year. How can I get the contents from the table to be populated in column D for my list? I have tried SUMPRODUCT, SUMIFS and INDEX (with MATCH) functions, but continue to get the #Value error. I have also array-entered each of the functions. I would like the value in D1 where MAKE=A1, MODEL=B1 and MODELYR=C1. -- TIA, Brad E. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting a table within a large worksheet | Excel Discussion (Misc queries) | |||
Comments at End of Large Table | Excel Discussion (Misc queries) | |||
pivot table using very large dataset | Excel Discussion (Misc queries) | |||
How do I link information from a large table into new table | Excel Worksheet Functions | |||
Pivot Table Too Large? | Excel Discussion (Misc queries) |