Isnumber and vlookup

Hi there,

I trying to extract alphabet and number with this fomula

=IF(ISNUMBER(RIGHT(N19, 2)),"",RIGHT(N19, 2)) it works and get the result but I try to vlookup the result with table.

Please help me...

I think we'd need to see a sample of the table data if your formula to extract the value worked.

Can you upload a sample workbook? (Double click the "Reply to Thread" button to be able to add a workbook)