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)
Ken Puls, CMA, MS MVP (Excel)
Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter
If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.