Thread: custom label
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
wishmyr wishmyr is offline
external usenet poster
 
Posts: 5
Default custom label

I tried the vlookup it didn't work, my table is a two variable data table

"Marcelo" wrote:

Hi,

do you have a table with the corresp name for the numbers ? like a chart
of accounts?

if yes,
use

=vlookup(b22,yourtable,2,false)

hth
regards from Brazil
Marcelo

"wishmyr" escreveu:

I want to replace the default format for cell d18 with a custom label of
"Customers", I know i need to use the quotation marks but i am unable to get
it to work. right now my cell as a formula =b22 and it displays 255 I want
255 to read Customes instead of the number, can you help?