darrensconfused
New Member
- Joined
- Apr 21, 2019
- Messages
- 10
Hello Everybody
I have a workbook i am trying to match the data from one table (sheet 1 Table) to another (sheet 2 Table) and produce the cost to the matching data. The table on sheet one has drop down cells with all the various sizes so i am hoping that once a combination that matches the table on sheet 2 it will display a cost from the match on sheet 2.
Sheet 1 Table
I have used the following formula successfully to match the data from one colum but cant get it to work across all three columns.
=INDEX(Sheet2!G42:J66,1,4,MATCH(E26,Sheet2!G42:G66,0))
you can download the workbook at this link if required
https://drive.google.com/open?id=15DLYUjbdXd1Naqt63YVGlwS3DR5MdtZh
Thanks very much in advance and i hope i have provided enough information
I have a workbook i am trying to match the data from one table (sheet 1 Table) to another (sheet 2 Table) and produce the cost to the matching data. The table on sheet one has drop down cells with all the various sizes so i am hoping that once a combination that matches the table on sheet 2 it will display a cost from the match on sheet 2.
Sheet 1 Table
I have used the following formula successfully to match the data from one colum but cant get it to work across all three columns.
=INDEX(Sheet2!G42:J66,1,4,MATCH(E26,Sheet2!G42:G66,0))
you can download the workbook at this link if required
https://drive.google.com/open?id=15DLYUjbdXd1Naqt63YVGlwS3DR5MdtZh
Thanks very much in advance and i hope i have provided enough information
Last edited by a moderator: