If, ISNA and Vlookup

Guys,

I'm using

=IF(ISNA(VLOOKUP(LEFT(RIGHT(B3,10),7),Sheet1!$A$2:$B$1390,2,FALSE))," ",VLOOKUP(LEFT(RIGHT(B3,10),7),Sheet1!$A$2:$B$1390,2,FALSE))

I am expecting it to lookup a value (B3) with the table referenced above. They will either come back with I, II or III or N/A.

I have had to do the right() and Left() to shave down a longer number eg xxxxxxx1234xx to just 1234 to tally up with the information given in the sheet.

The problem is that every thing is coming back as " ".

If I manually do the search then I find the items do exist within the sheet as I,II or III.


can someone give me a pointer as to where i've gone wrong on this?

Thanks,

thats what I was missing. Sorted now.