Vlookup Excel, link to another sheet

Question

I am trying to create a simple VLOOKUP function for my table using the following command: On the first sheet

=VLOOKUP("Salary",'December 2015_natwest_download'!$D$4:$E$43,1,FALSE)

This is the sheet I'm trying to use:

The sheet I'm trying to reference is:

Value          Category
======= ==========
£530.00        Charlotte Owing
-£53.00        Gym
-£16.47        Water
-£67.00        Phone
-£11.01        Presents
-£14.40        Eating out
-£100.00       Food
-£65.00        Other

But when I paste the VLOOKUP code into my excel, it returns NA. Can anyone see what causes the error?

Answer 1

The VLOOKUP function is designed to search for a value in the left corner of a data block and return the corresponding value from a column to the right.

, INDEX/MATCH.

( , ), SUMIF SUMIFS. , , .

E4: F4:

=INDEX('December 2015_natwest_download'!A:A, MATCH(D4, 'December 2015_natwest_download'!B:B, 0))
=SUMIFS('December 2015_natwest_download'!A:A,'December 2015_natwest_download'!B:B, D4)

, SUMIFS F5 Gym.