Thread: replace a number with a string from database
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
IamN2Deep IamN2Deep is offline
external usenet poster
  
Posts: 1
Default replace a number with a string from database

I don't think you need a macro. A simple vlookup formula will work.

Place this formula in cell E1 and use cell D1 as your input cell.

=VLOOKUP(D1,A1:B60,2,FALSE)


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

Reply With QuoteReply With Quote