Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lookup data in multiple tables
I have data organized as:
product name1 Heading 1, heading 2, heading 3, heading 4 row name 1, data, data, data row name 2, data, data, data row name 3, data, data, data row name 4, data, data, data Total, data, data, data product name 2 Heading 1, heading 2, heading 3, heading 4 row name 1, data, data, data row name 2, data, data, data Total, data, data, data The issue is that i have many product names (over 25). The data is always found in the named row "total" and column 4 AFTER finding the name of the table. I need a formula that basically says, if you find "product name X" then return the value the row named "total" and found X columns to the right of that named row. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lookup data in multiple tables
use the VLOOKUP function
"Anthony" wrote: I have data organized as: product name1 Heading 1, heading 2, heading 3, heading 4 row name 1, data, data, data row name 2, data, data, data row name 3, data, data, data row name 4, data, data, data Total, data, data, data product name 2 Heading 1, heading 2, heading 3, heading 4 row name 1, data, data, data row name 2, data, data, data Total, data, data, data The issue is that i have many product names (over 25). The data is always found in the named row "total" and column 4 AFTER finding the name of the table. I need a formula that basically says, if you find "product name X" then return the value the row named "total" and found X columns to the right of that named row. . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lookup data in multiple tables
I misunderstood. sorry
use MATCH to find the row for the product the use MATCH with OFFSET to get the value of the total row, and finally use OFFSET with this value to get the result =OFFSET(A1,MATCH("Total",OFFSET(A1,MATCH(H15,A:A,F ALSE),0,1000),FALSE)+MATCH(H15,A:A,FALSE)-1,4) in this H15 is a product name "Anthony" wrote: I have data organized as: product name1 Heading 1, heading 2, heading 3, heading 4 row name 1, data, data, data row name 2, data, data, data row name 3, data, data, data row name 4, data, data, data Total, data, data, data product name 2 Heading 1, heading 2, heading 3, heading 4 row name 1, data, data, data row name 2, data, data, data Total, data, data, data The issue is that i have many product names (over 25). The data is always found in the named row "total" and column 4 AFTER finding the name of the table. I need a formula that basically says, if you find "product name X" then return the value the row named "total" and found X columns to the right of that named row. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple variable lookup tables | Excel Worksheet Functions | |||
Setting up data validation and lookup tables...? | Excel Discussion (Misc queries) | |||
Lookup tables with multiple columns | Excel Discussion (Misc queries) | |||
lookup and choose wih multiple tables of unequal column lengths | Excel Discussion (Misc queries) | |||
Using Multiple LOOKUP tables | Excel Discussion (Misc queries) |