I have a simple VLOOKUP function that I want to use to call value information (£) from a separate tab depending on the ID used:
Sheet1 has 3 columns:
- Column A: ID
- Column B: Name
- Column C: Value
Sheet 2 has the VLOOKUP: =VLOOKUP(A1,Sheet1!A1:A50,3,FALSE)
However, '#REF!' comes up when I use the above formula.
What am I missing?
Thanks
Bookmarks