G
gcw
I need a help writing this formula to reference 2 (two) points to find an
answer
In Worksheet (Main) Cell: D4 I need populated the Month Target (Jan/08) for
"HJ170"
My lookup table would be Worksheet (TLTargets) and the area would be
B2:Q42
(The correct answer would be value of B4 on TLTarget worksheet)
SheetName: Main
A B C D E Column
2 Jan/08 Feb/08
3 HJ170 T/L Core 0.17 0.01
4 Target ????
5 Non Core 0.61 0.76
6 Target
Row
SheetName: TLTargets Table B2:Q42
A B C Column
1 TOTAL Jan-08 Feb-08
2 Quality Control 0.65 0.65
3 IO 1 Kaizen 0.50 0.50
4 HJ170 0.50 0.50
5 HJ270 0.50 0.50
Row
answer
In Worksheet (Main) Cell: D4 I need populated the Month Target (Jan/08) for
"HJ170"
My lookup table would be Worksheet (TLTargets) and the area would be
B2:Q42
(The correct answer would be value of B4 on TLTarget worksheet)
SheetName: Main
A B C D E Column
2 Jan/08 Feb/08
3 HJ170 T/L Core 0.17 0.01
4 Target ????
5 Non Core 0.61 0.76
6 Target
Row
SheetName: TLTargets Table B2:Q42
A B C Column
1 TOTAL Jan-08 Feb-08
2 Quality Control 0.65 0.65
3 IO 1 Kaizen 0.50 0.50
4 HJ170 0.50 0.50
5 HJ270 0.50 0.50
Row