Thread: custom label

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?

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?

here is a sample of what i'm working on

$255 $20 $21 $22
10 (2,145) (1,845) (1,545)
12 (1,905) (1,545) (1,185)
14 (1,665) (1,245) (825)
16 (1,425) (945) (465)
18 (1,185) (645) (105)

I need the 255 to say customers ( that sell has a formula of =b22)

I hope this helps out a little better



"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?

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?