# Need Formula

#### shaylynch

##### Board Regular
Hi all,
i am in a spot of bother, i am working on an Expense sheet for work and our employees travel around a bit (internationally), i need to perform a calculation to give the VAT rate. what i have is a table of what country gives what VAT rate(have dummy data at the mo).in their expense sheet they have a colum for expense type and also what country, and with that info i need to be able to calculate in another colum, what rate it should be by getting it from the table.has anyone got any ideas? i have attached the table to show. i don't know of any lookup function that could do this,but maybe there is

Shay
Company Database.xls
EFGHIJKL
67ChooseexpensetypeIrelandGreatBritainFranceHollandJapanUSA
68Airtravel21%15%
69CarJourney(owncar)15%12%
70Carpark13%15%
71CarTolls13%24%
72TrainJourney13%15%
73Taxi13%22%
74Accommodation21%12%
75Meal20%23%
76Entertainment(nameclients)15%23%
77Phone21%21%
78MobilePhone13%12%
79Other15%12%
Monthly Expense

### Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
Hi,

Try:

=VLOOKUP(B17,A2:H13,MATCH(A17,C1:H1,0)+2,0)
Book1
ABCDEFGHI
1ChooseexpensetypeIrelandGreat BritainFranceHollandJapanUSA
2Air travel21%15%
3Car Journey (own car)15%12%
4Car park13%15%
5Car Tolls13%24%
6Train Journey13%15%
7Taxi13%22%
8Accommodation21%12%
9Meal20%23%
10Entertainment (name clients)15%23%
11Phone21%21%
12Mobile Phone13%12%
13Other15%12%
14
15
16
17Great BritainCar Tolls24%
18
Sheet9

Legend Fairwinds

worked an absolute treat

thank you so much

Shay

Replies
3
Views
147
Replies
4
Views
455
Replies
8
Views
173
Replies
1
Views
264
Replies
11
Views
266

1,196,325
Messages
6,014,650
Members
441,834
Latest member
GHOSTOF309

### 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.

### Which adblocker are you using?

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