Need Formula

shaylynch

Board Regular
Joined
Nov 11, 2002
Messages
163
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

thanks in adavnce

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

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
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
 
Upvote 0

Forum statistics

Threads
1,223,497
Messages
6,172,644
Members
452,467
Latest member
colelkay

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
Back
Top