Excel help

[Philip123]

I am wanting to create a value that responds to values placed in a different table.

For example:
Week Type          Cost
1       Food         10
2       Food         12
1       Transport   15

I want the value to pick up the cost where week 1 and Food appear. How do I do that?

[strollin]

If I understand your question correctly, I believe you want to use the VLOOKUP function where you  can specify which columns to search on and which values to retrieve.

[Mark.]

or perhaps using SUMIFS

if you want to find the cost of all your Food for week 1, something like this would do it.

=SUMIFS(C1:C3,A1:A3,"=1",B1:B3,"=Food")

where, from your example, Week is column A, Type is column B and Cost is column C.

[Philip123]

That's great thank you!
I used the SUMIFS function and worked like a dream

[Mark.]

good news, thanks for letting us know.

it's amazing what Excel can do, I'm yet to find something it couldn't do for me!

and if you are just starting out, wait till you discover macros and the VBA side of it - even better then.