Expense spreadsheet to automatically code to the selected cost centre

[MushroomFace]

I need a formula to automatically calculate codes (cost centres) for an expense spread sheet.

My spreadsheet will have departments..
E.G Finance (cost centre 300), HR(405), IT(450)

It will also have expense type
E.G Travel (8000), accomodation (8100), food (8120)

If I chose Finance and travel, the cell with the formula should be 3008000. If the formulas have to be split into two cells (that's fine i will concatenate them) BUT it's be great if someone could do this in one.

Thanks in advance

[Ace_XL]

Assume

Departments and cost centres in column A & B
Expense type and code in Column C & D

E1 & F1 contain your choices

Use
=iferror(index(b:b,match(e1,A:a,0)),"")&iferror(index(d:d,match(f1,c:c,0)),"")

[Harribone]

Can you upload a sample file with mock data which has the same/similar layout to your real data. That way we can see how Finance (300) is stored in your sheet etc. as we don't know if this is all in one cell or two cells
Also need to know how you choose plan to Finance and Travel on your sheet that way we can look up these items and get the 300 and 8000 correctly for you.

To upload a file click on Go Advanced below and then choose Manage Attachments.

[ychartra01]

MushroomFace see attached Excel example.

[Richard Buttrey]

Does the attached help

[MushroomFace]

I didn't even realise i could use two V Lookups at the same time.

Cheers all!