Buddhaboy32
New Member
- Joined
- Apr 15, 2020
- Messages
- 8
- Office Version
- 2010
- Platform
- Windows
Good day
I need to index / match multiple tables to get a result in IMAGE 1.
EG: If Item FCT_8004_CER is selected where the pressure = 7.6 BAR then L/MIN = 2.82
SEE IMAGE 2 for the 1st table
I got it working with a single table.
My problem comes in with the 2nd table. See IMAGE 3
The values for the BARS and L/Min differ in table 1 (Image 2) and table 2 (Image 3) as does the type of nozzle.
So, what i am trying to achieve in IMAGE 1 is that if I select the following:
Category = FULL CONE Then CODE = FCT_80_04_CER then Part Number = 8259381
TYPE = MAG-CH-04 and Colour = Red with Image
BAR (Drop List) = 3.4 (Values in Table 2) (I304:N304) and L/Min = Corresponding Value (eg. 1.94) (value shows automatically)
See image 4.
I need to do the same for image 3.
I need to index / match multiple tables to get a result in IMAGE 1.
EG: If Item FCT_8004_CER is selected where the pressure = 7.6 BAR then L/MIN = 2.82
SEE IMAGE 2 for the 1st table
I got it working with a single table.
My problem comes in with the 2nd table. See IMAGE 3
The values for the BARS and L/Min differ in table 1 (Image 2) and table 2 (Image 3) as does the type of nozzle.
So, what i am trying to achieve in IMAGE 1 is that if I select the following:
Category = FULL CONE Then CODE = FCT_80_04_CER then Part Number = 8259381
TYPE = MAG-CH-04 and Colour = Red with Image
BAR (Drop List) = 3.4 (Values in Table 2) (I304:N304) and L/Min = Corresponding Value (eg. 1.94) (value shows automatically)
See image 4.
I need to do the same for image 3.