Lookup Table for expenses

[bwaaack]

What would be the best way to create a lookup table for my expenses. If A2 contains X then it pulls from the lookup table.

Example.

[TABLE="width: 251"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Expense[/TD]
[TD]Category[/TD]
[/TR]
[TR]
[TD]Vons store[/TD]
[TD]Grocery[/TD]
[/TR]
[TR]
[TD]Mail chimp[/TD]
[TD]Advertising[/TD]
[/TR]
[TR]
[TD]Cheveron gas[/TD]
[TD]Auto[/TD]
[/TR]
</tbody>[/TABLE]

 

[kweaver]

This is not particularly clear how your sheet is set-uip and what you're trying to find.