Row\Col |
A |
B |
C |
D |
E |
F |
G |
H |
I |
1 |
|
|
|
Will Return the match in column A to B, or False |
Type here Signed off or Issue |
Will return the row number where the match is found or False |
Returns the next smallest number from Array F2:F11 |
Returns value from column A based on row number |
Remove error |
2 |
a |
Signed off |
|
=IF(B2:B11=E2,A2:A11,FALSE) |
Signed off |
=IF(B2:B11=E2,ROW(A2:A11)-ROW(A1),FALSE) |
=SMALL(F2:F11,ROW(F1:F10)) |
=INDEX(A2:A11,G2:G11,1) |
=IF(ISERROR(H2:H11),"",H2:H11) |
3 |
b |
Issue |
|
=IF(B2:B11=E2,A2:A11,FALSE) |
|
=IF(B2:B11=E2,ROW(A2:A11)-ROW(A1),FALSE) |
=SMALL(F2:F11,ROW(F1:F10)) |
=INDEX(A2:A11,G2:G11,1) |
=IF(ISERROR(H2:H11),"",H2:H11) |
4 |
c |
Signed off |
|
=IF(B2:B11=E2,A2:A11,FALSE) |
|
=IF(B2:B11=E2,ROW(A2:A11)-ROW(A1),FALSE) |
=SMALL(F2:F11,ROW(F1:F10)) |
=INDEX(A2:A11,G2:G11,1) |
=IF(ISERROR(H2:H11),"",H2:H11) |
5 |
d |
Signed off |
|
=IF(B2:B11=E2,A2:A11,FALSE) |
|
=IF(B2:B11=E2,ROW(A2:A11)-ROW(A1),FALSE) |
=SMALL(F2:F11,ROW(F1:F10)) |
=INDEX(A2:A11,G2:G11,1) |
=IF(ISERROR(H2:H11),"",H2:H11) |
6 |
e |
Issue |
|
=IF(B2:B11=E2,A2:A11,FALSE) |
|
=IF(B2:B11=E2,ROW(A2:A11)-ROW(A1),FALSE) |
=SMALL(F2:F11,ROW(F1:F10)) |
=INDEX(A2:A11,G2:G11,1) |
=IF(ISERROR(H2:H11),"",H2:H11) |
7 |
f |
Issue |
|
=IF(B2:B11=E2,A2:A11,FALSE) |
|
=IF(B2:B11=E2,ROW(A2:A11)-ROW(A1),FALSE) |
=SMALL(F2:F11,ROW(F1:F10)) |
=INDEX(A2:A11,G2:G11,1) |
=IF(ISERROR(H2:H11),"",H2:H11) |
8 |
g |
Signed off |
|
=IF(B2:B11=E2,A2:A11,FALSE) |
|
=IF(B2:B11=E2,ROW(A2:A11)-ROW(A1),FALSE) |
=SMALL(F2:F11,ROW(F1:F10)) |
=INDEX(A2:A11,G2:G11,1) |
=IF(ISERROR(H2:H11),"",H2:H11) |
9 |
h |
Issue |
|
=IF(B2:B11=E2,A2:A11,FALSE) |
|
=IF(B2:B11=E2,ROW(A2:A11)-ROW(A1),FALSE) |
=SMALL(F2:F11,ROW(F1:F10)) |
=INDEX(A2:A11,G2:G11,1) |
=IF(ISERROR(H2:H11),"",H2:H11) |
10 |
i |
Signed off |
|
=IF(B2:B11=E2,A2:A11,FALSE) |
|
=IF(B2:B11=E2,ROW(A2:A11)-ROW(A1),FALSE) |
=SMALL(F2:F11,ROW(F1:F10)) |
=INDEX(A2:A11,G2:G11,1) |
=IF(ISERROR(H2:H11),"",H2:H11) |
11 |
j |
Issue |
|
=IF(B2:B11=E2,A2:A11,FALSE) |
|
=IF(B2:B11=E2,ROW(A2:A11)-ROW(A1),FALSE) |
=SMALL(F2:F11,ROW(F1:F10)) |
=INDEX(A2:A11,G2:G11,1) |
=IF(ISERROR(H2:H11),"",H2:H11) |
Bookmarks