HELP NEEDED! confused

[Excelhurtsmybrain]

Thanks for actually taking you time to help guys. im a learning novie at the moment so i dont know if my explanaition are clear

so i hosted pics of the sheet and colour coded it (YOU WILL NEED TO VIEW THE PICS TO UNDERSTAND THE COLOR CODE).

image 1: this should be the table where i got all my values from and the table where i think i need to get the hire charges from (green). the values in my scroll down menu come from here

image2:
blue: values are refrenced from the combo boxes and the check box aswell as the outcome of the hire charge e.g. a15 (=a9). so when ever the combo boxes is changed the value changes and when the hire charge is listed above it also shows below in the hire charge cell

red: these are the 2 comboboxes/list. so when i click i scroll down i pick a value e.g. type of bike, hire duration

green: the should be the hire charge value based on which bike i picked from the list in red and which hire duration
(bare in mind as the table shows the 2 different hire durations are what determin the bike price)

brown: this is extra i just need a button that puts a number in the box and resets the whole sheet for a new transaction entry

to clarify again. what i need is some sort of code that i will enter in the hire charge cell(green) so that as i change the cycle types and hire duration(red), it shows a value (the values are to be taken from the table in image 1)

ive tried vlookup and researched match and offset but im sure there is something else i can do

i hope i made this clear and i repeat again

i do not want to ask to much of anyone so if i can just be told the methods i need il do the research and go ahead and do them thank you for taking your time to help

image 1:http://img694.imageshack.us/img694/6467/image2vq.jpg
image 2: http://img30.imageshack.us/img30/4007/imagedt.jpg

HEEEELLLP!

 

[Domenic]

For some reason, I'm not able to see the data for the first image you've posted (I just see a black screen). Can you post the sample data in text form?

 

[Excelhurtsmybrain]

ok

(H) is for the heading. but it is in a list so the list so rather than going down many rows its in one cell.

Row** column(A)** column(B)**column(C)**
1**Cycle types(H)** Hire Duration(H)** Hire Charge(H)

the values for cylce types and hire duration are in a list but hire charge is a simple cell that i need to enter data into

i get this charge information from a table that resemble this one below
aswell as the list of bikes and hire duration(half day/full day)

these are the rates


Row**Column(A)**Column(B)**Column(C)
23**Cylcle(H)**Half Day(H)**Full Day(H)
24**kids bike**12 **30
25**tandem**4 **23
26**buggy**7 **24
27**cycle**8 **34

hope this helps because im confused about all the methods

 

[yytsunamiyy]

Try the following:

Excel Workbook
	A	B	C
1	Bike type	Half day	full day
2	a	1	2
3	b	3	4
4	c	5	6
5	d	7	8
6	e	9	10
Tabelle1

Excel Workbook
	A	B	C
2	Bike	Hire	fee
3	a	full day	2
Tabelle2

Cell Formulas
Range	Formula
C3	=INDEX(Tabelle1!A1:C6,MATCH(Tabelle2!A3,Tabelle1!A1:A6,0),MATCH(Tabelle2!B3,Tabelle1!A1:C1,0))

Data in Tabelle2 A3 is validated against Tabelle1!A2:A6 and data in Tabelle2 B3 is validated against Tabelle1!B1:C1.

Try this simple sample in a fresh workbook and once understood transfer to your wb. Adjust ranges to suit.

 

[Excelhurtsmybrain]

thanks i think index and match is the one to use ill try that now...

 

[Excelhurtsmybrain]

Can i just ask what "tabelle" stand for is it a defined name or somthing else?

 

[Domski]

Tabble1 and Tabelle 2 are the names of the worksheets.

Dom

 

[Excelhurtsmybrain]

it worked thank you so much for the help guys