Lookups

[lollipop1471]

Hi,

I have this table:

Sessions	No. of Spaces
	20	19	18
5	400	380	360
4	320	304	288
3	240	228	216
2	160	152	144

<colgroup><col><col span="3"></colgroup><tbody>
</tbody>

Then I have:

	Spaces	Sessions
Day 1	20	4
Day 2	19	2
Day 3	19	4
Day 4	18	4
Day 5	18	2
Total			-

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

Spaces and sessions are drop down lists that can be changed and in the column next to sessions I would like it to find the corresponding figure from the table above it.
What's the best formula to use and how would I write it?

thanks

 

[Marcílio_Lobão]

lollipop1471, Good afternoon.

Scenario:

	A	B	C	D
1	Sessions		N° spaces
2		20	19	18
3	5	400	380	360
4	4	320	304	288
5	3	240	228	216
6	2	160	152	144

<tbody>
</tbody>

	G	H	I	J
1		Spaces	Sessions
2	Day 1	20	4	FORMULA
3	Day 2	19	2
4	Day 3	19	4
5	Day 4	18	4
6	Day 5	18	2
7			Total	=SUM(J2:J6)

<tbody>
</tbody>

Try to use:

J2 --> =VLOOKUP(I2, $A$3:$D$6, MATCH(H2, $B$2:$D$2, 0)+1, 0)

Copy it down.

Is that what you want?
I hope it helps.

 

[lollipop1471]

Thank you!!!!!
yes it worked!