Thread: Lookup Function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Lookup Function
=IF(X3="A15C",15,"")

"Wasdell" wrote:

I am trying to lookup an exact text cell and convert it to a numeric value eg

If cell x3 = A15C then the answer will be 15
Reply With QuoteReply With Quote