Isnumber and vlookup

mytipi

New member
Joined
Apr 10, 2012
Messages
1
Reaction score
0
Points
0
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...
 

Ken Puls

Administrator
Staff member
Joined
Mar 13, 2011
Messages
2,524
Reaction score
6
Points
38
Location
Nanaimo, BC, Canada
Website
www.excelguru.ca
Excel Version(s)
Excel Office 365 Insider
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)
 
Top