I have an excel spreadsheet with two worksheets. And the following formula is not pulling the data.
=VLOOKUP($A$2:$A$566,'Module Type Info'!$A$2:$D$97,4,FALSE)
In sheet 1, I am using all data in column 1 for the lookup
In sheet 2, I have selected the first 4 columns of data for array
I want to pull data from sheet 2, column 4 into sheet 1
Both tabs are sorted alphabetically.
Confirmed that the value in column 4 of sheet 2 is a TEXT field.
Why is this not pulling the info from sheet 2 into sheet 1
Solved by F. L. in 25 mins