Vlookup wont work !!

[blossomthe2nd]

Hi guys

Hope someone can help,

I have a spreadsheet that I have imported the data infrom a PRN file. In column N I have a formula to pull out part of the data =MID(J1,18,9)

Then on another tab I have a table. What I am trying to do is a vlookup from sheet 1 to sheet 2 using the N column as reference !!

=VLOOKUP(N1,'Actual Table'!A:C,3,FALSE)

I have also tried

=VLOOKUP(MID(J1,18,9),'Actual Table'!A:C,3,FALSE)

I keep getting N/A#s but I know that results should be different. I have tried to format all the cells as Text , but to no avail

Can anyone advise ?

Thanks

 

[Jonmo1]

MID returns a TEXT string.
And I'm guessing the data in Column A on the other sheet is Numeric.

Try changing
=MID(J1,18,9)
to
=MID(J1,18,9)+0


Hope that helps.

 

[jasonb75]

Where in the Actual Table is the match for N1?

 

[blossomthe2nd]

MID returns a TEXT string.
And I'm guessing the data in Column A on the other sheet is Numeric.

Try changing
=MID(J1,18,9)
to
=MID(J1,18,9)+0

Haha so simple

Thanks Jonmo1 -- Works perfect

No worries Jason we're up and running again

Thanks