looking up data...HELP!!!

ReportsTeam

New Member
I have a table (as below) and I need to lookup for example, the number of how many holidays were booked for uk etc (Not DSUM), any other ideas?

uk us europe other
flight 18 20 14 105
holiday 10 17 22 200
other 13 21 25 174
This message was edited by ReportsTeam on 2002-10-18 05:36

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Andrew Poulsom

MrExcel MVP
Formula is:

=VLOOKUP("holiday",A2:E4,MATCH("uk",A1:E1,0),FALSE)

Change range references to suit.

ReportsTeam

New Member
You Star....thank you very much

MrExcel MVP
On 2002-10-18 05:36, Andrew Poulsom wrote:
Formula is:

=VLOOKUP("holiday",A2:E4,MATCH("uk",A1:E1,0),FALSE)

Change range references to suit.

Why do you use both 0 and FALSE in the same formula while they mean same thing?

Andrew Poulsom

MrExcel MVP
I'm a creature of habit!

Replies
4
Views
304
Replies
5
Views
130
Replies
4
Views
832
Replies
3
Views
259
Replies
6
Views
708

1,181,686
Messages
5,931,421
Members
436,789
Latest member
portugeezers

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.

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

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