excelgal2016
New Member
- Joined
- Dec 14, 2016
- Messages
- 21
- Office Version
- 2019
- Platform
- Windows
*** UPDATE *** My bad, I didn't realize the array was wrong (i column only!)!
Spent with this about an hour! Can't find how to delete a post neither. SORRY. 
Hi all,
I got some great help from this forum previously, so I thought I'll return.
I am trying to do a simple VLOOKUP function between 2 tabs in the same Excel file, but I keep getting a REF error.
The data in tab "Data" is formatted as a table - may it have to do anything with that? Also when I do the VLOOKUP to return the first column, it works OK.
Any ideas how to fix this?
Thank you!
Excelgal


Hi all,
I got some great help from this forum previously, so I thought I'll return.
I am trying to do a simple VLOOKUP function between 2 tabs in the same Excel file, but I keep getting a REF error.


The data in tab "Data" is formatted as a table - may it have to do anything with that? Also when I do the VLOOKUP to return the first column, it works OK.
Any ideas how to fix this?
Thank you!
Excelgal
Last edited: