Hello,
I am attempting to find a lookup formula which ignores a value in a table and returns to me the value I require.
Below is an example of what I'm attempting to do;
Specific ID's have Requirements and those ID's are attached to a lane.
In table 1 I want the Lane to show the Requirement however because multiple ID's in Table 2 show up which cause the lookup to fail in table 1.
Is the a simple formula which will allow the lookup to ignore the 0's and just return the Requirement value from table 2.
Any help would be appreciated!
I am attempting to find a lookup formula which ignores a value in a table and returns to me the value I require.
Below is an example of what I'm attempting to do;
Example.xlsx | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | |||
1 | Table 1 | Result Im Getting | Table 2 | Table 3 | ||||||||||
2 | Lane | REQ | REQ2 | Lane | ID | REQ1 | REQ2 | ID | REQ | REQ2 | ||||
3 | 10 | STORE | 0 | 10 | 114 | STORE | 0 | 114 | STORE | |||||
4 | 12 | 0 | 0 | 10 | 114 | STORE | 0 | 224 | HOLD | |||||
5 | 14 | 0 | HOLD | 10 | 200 | 0 | 0 | |||||||
6 | 16 | STORE | 0 | 12 | 200 | 0 | 0 | |||||||
7 | 18 | 0 | 0 | 12 | 114 | STORE | 0 | |||||||
8 | 14 | 224 | 0 | HOLD | ||||||||||
9 | 14 | 224 | 0 | HOLD | ||||||||||
10 | Table 1 | Result I Want | 14 | 300 | 0 | 0 | ||||||||
11 | Lane | REQ | REQ2 | 16 | 114 | STORE | 0 | |||||||
12 | 10 | STORE | 0 | 18 | 300 | 0 | 0 | |||||||
13 | 12 | STORE | 0 | 18 | 300 | 0 | 0 | |||||||
14 | 14 | 0 | HOLD | 18 | 224 | 0 | HOLD | |||||||
15 | 16 | STORE | 0 | |||||||||||
16 | 18 | 0 | HOLD | |||||||||||
17 | ||||||||||||||
Sheet1 |
Specific ID's have Requirements and those ID's are attached to a lane.
In table 1 I want the Lane to show the Requirement however because multiple ID's in Table 2 show up which cause the lookup to fail in table 1.
Is the a simple formula which will allow the lookup to ignore the 0's and just return the Requirement value from table 2.
Any help would be appreciated!