I am using two worksheets in Excel but am having problems with using VLOOKUP.
Sheet 2:- CATEGORY_ID CATEGORY_NAME
I essentially want to add the CATEGORY_NAME in the 3rd column of sheet 1, so I am using the following:-
However, this only returns:-
There are 17000 rows in worksheet 1. All rows have a category ID. Worksheet 2 only has 20 rows, including the header row (so 19 unique category ID/names). What am I doing wrong here? Driving me insane!