Lookups

lollipop1471

New Member
Joined
Oct 18, 2016
Messages
4
Hi,

I have this table:

Sessions No. of Spaces
201918
5400380360
4320304288
3240228216
2160152144

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

Then I have:

SpacesSessions
Day 1204
Day 2192
Day 3194
Day 4184
Day 5182
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
 

Some videos you may like

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

Marcílio_Lobão

Well-known Member
Joined
Oct 7, 2013
Messages
712
Platform
  1. Windows
lollipop1471, Good afternoon.

Scenario:

A
B
C
D
1
Sessions N° spaces
2
201918
3
5400
380360
4
4320304288
5
3240228216
6
2160152144

<tbody>
</tbody>


GHIJ
1
SpacesSessions
2
Day 1204FORMULA
3
Day 2192
4
Day 3194
5
Day 4184
6
Day 5182
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,418
Messages
5,596,028
Members
414,039
Latest member
southike

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top