Thread: vlookup
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default vlookup

she has a conversion table in L2:M12

--
Regards,
Tom Ogilvy

"Alan Beban" wrote in message
...
Tom Ogilvy wrote:
You can't type letters into a cell in column D and have them appear as
numbers using a formula.


Well, it certainly isn't clear what the OP is needing to do, but if a is
defined to be 1, b is defined to be 2 and d is defined to be 3 (c is not
available as a defined name), then typing

=a&b&d into Cell D1 will return 123 to that cell.

Alan Beban