#1   Report Post  
Big Jones
 
Posts: n/a
Default Vlookup problem

Can someone point me in the right direction please.

I have the following
2 worksheets - named "results" & "Data"
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)
Data sheet has 3 columns,
A B C
1 size weg cemp
2 0.75 100 90

If I select 0.75 from the drop down list on combo 1, I then need to choose
the name from combo 2, the value of which is summed up elsewhere, how do I
get the information from data sheet so I can SUM the value in another cell in
reults sheet?
I hope that makes sense.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VLOOKUP Problem Tosca Excel Worksheet Functions 7 July 23rd 05 10:43 PM
vlookup problem idcreek Excel Worksheet Functions 4 May 24th 05 01:07 PM
VLOOKUP problem Wazooli Excel Discussion (Misc queries) 5 March 26th 05 01:52 PM
Problem with VLOOKUP and drop-down lists! Vicki Excel Worksheet Functions 2 March 18th 05 10:52 PM
VLOOKUP problem Jason Excel Worksheet Functions 2 January 14th 05 10:39 PM


All times are GMT +1. The time now is 08:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"