VLookUp across 2 worksheets not working!

Hi there,

I am a basic Excel user learning to do new things

I am trying to do attempt a VLOOKUP across multiple worksheets I've looked at loads of of youtube videos and can't find out any solutions to the issue I am experiencing:

- VLOOKUP is returning correct information for Joanne but not for Raewyn and those customers below it.

Formula being used is - =VLOOKUP($B2,'QLD South All Data'!$A2:$J245,10, FALSE)

Excel - Issue 1.png

For the life of me I can't work out why!

This is work task and would appreciate your help.

Cheers
Jenn