Using Vlookup to compare and validate data
 

I have the following
2 worksheets - named "results" & "Motors"
Results sheet has 2 comboboxes, one sits on cell C5 in column "motorsize"
the other sits on D5 in column "motorname"
Combo 1 listfill range is from results sheet A20:A30 (linked cell C5)
Combo 2 listfill range is from results sheet D12:D14 (linked cell D17)
Motors sheet has 3 columns,
A B C
1 size weg cemp
2 0.75 100 90
3 1.1 150 175
4 etc etc etc
I select 0.75 (motorsize) from the drop down list on combo 1 in results
sheet, I then need to choose
the name from combo 2 (motorname), the value of which is summed up in cell
G5 (total), how do I
get the information from Motors sheet so I can SUM the value in cell G5 in
results sheet?
This is what I have so far, but get #N/A in my total column G5
Cell D5 contains =VLOOKUP(C5,Motors!A2:C12,1,FALSE)
I hope that makes sense.
Any help would be appreciated.
Andy

try
=VLOOKUP(C5,Motors!A1:C12,match(d17,motors!A1:C1,0 ),FALSE)
Your lookup reference must contain the whole table you are looking in
--
paul
remove nospam for email addy!



"Big Jones" wrote:

I have the following
2 worksheets - named "results" & "Motors"
Results sheet has 2 comboboxes, one sits on cell C5 in column "motorsize"
the other sits on D5 in column "motorname"
Combo 1 listfill range is from results sheet A20:A30 (linked cell C5)
Combo 2 listfill range is from results sheet D12:D14 (linked cell D17)
Motors sheet has 3 columns,
A B C
1 size weg cemp
2 0.75 100 90
3 1.1 150 175
4 etc etc etc
I select 0.75 (motorsize) from the drop down list on combo 1 in results
sheet, I then need to choose
the name from combo 2 (motorname), the value of which is summed up in cell
G5 (total), how do I
get the information from Motors sheet so I can SUM the value in cell G5 in
results sheet?
This is what I have so far, but get #N/A in my total column G5
Cell D5 contains =VLOOKUP(C5,Motors!A2:C12,1,FALSE)
I hope that makes sense.
Any help would be appreciated.
Andy