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

Hello Jenn005 and welcome to Excel Forum.
You might try: =INDEX('QLD South All Data'!J$2:J$245,MATCH(B2,'QLD South All Data'!B$2:B$245,0))
That said it is hard to understand an issue from just a screenshot. It would help us to help you if you could upload the workbook from which the screen shot is taken. It would also help if you could manually include your expected results so that we can attempt the replicate them using formulas/code.
To upload a sample workbook click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
Let us know if you have any questions.