Formula help on HLookup / VLookup ??

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
 
G

gcw

porter444 said:
=VLOOKUP(A2,TLTargets!A2:Q42,2,FALSE)


I also want it to scan across the columns and find the correct column
(Month), in this case it is correct, but what if I was looking for May 08.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top