looking up data...HELP!!!

[ReportsTeam]

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?

thanks in advance.

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

 

[Andrew Poulsom]

Formula is:

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

Change range references to suit.

 

[ReportsTeam]

You Star....thank you very much

 

[Aladin Akyurek]

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]

I'm a creature of habit!