what results are you expecting - your looking up text , and finding nearest value with a TRUE , so text may return unexpected results because of the assignment excel gives to text
try
=VLOOKUP(B3,Sheet2!$B$2:$C$10,2,FALSE)
so you are looking up an exact value
you are including the titles on sheet 2 , so they are also looked up nearest value - i cant remember how excel assigns text order
Hi,
On your VLOOKUP formula, you've used the fourth argument, TRUE which stands for Approximate Match. Well, if your data isn't sorted you won't get your expected results. So, better you look for the exact match. So use FALSE instead of TRUE.
Here's the updated formula: