Using Vlookup to compare and validate data

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

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