converting text to numbers
 

I have columns "A", "B", and "C". I want to place an "X" in only one of the
cells in the row below. If x is in column "A", it will =4. If x is in column
"B", it will =8. If x is in column "C", it will =15. How do I create this
formula so that whatever x equals, that number will be displayed in cell F2?

Thanks in advance,

--
Have a great day!

converting text to numbers
 

Hi,

see if it helps you

on F2
=lookup("x",a2:c2,{4,8,15})

hth

--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"northerner" escreveu:

I have columns "A", "B", and "C". I want to place an "X" in only one of the
cells in the row below. If x is in column "A", it will =4. If x is in column
"B", it will =8. If x is in column "C", it will =15. How do I create this
formula so that whatever x equals, that number will be displayed in cell F2?

Thanks in advance,

--
Have a great day!

converting text to numbers
 

Marcelo,
I tried that and it displays NA. Any other suggestions?
--
Have a great day!


"Marcelo" wrote:

Hi,

see if it helps you

on F2
=lookup("x",a2:c2,{4,8,15})

hth

--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"northerner" escreveu:

I have columns "A", "B", and "C". I want to place an "X" in only one of the
cells in the row below. If x is in column "A", it will =4. If x is in column
"B", it will =8. If x is in column "C", it will =15. How do I create this
formula so that whatever x equals, that number will be displayed in cell F2?

Thanks in advance,

--
Have a great day!

converting text to numbers
 

shows NA if you do not have any X in a, b or c column, you can use

=if(iserror((lookup("x",a2:c2,{4,8,15}))),"",(look up("x",a2:c2,{4,8,15})))

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"northerner" escreveu:

Marcelo,
I tried that and it displays NA. Any other suggestions?
--
Have a great day!


"Marcelo" wrote:

Hi,

see if it helps you

on F2
=lookup("x",a2:c2,{4,8,15})

hth

--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"northerner" escreveu:

I have columns "A", "B", and "C". I want to place an "X" in only one of the
cells in the row below. If x is in column "A", it will =4. If x is in column
"B", it will =8. If x is in column "C", it will =15. How do I create this
formula so that whatever x equals, that number will be displayed in cell F2?

Thanks in advance,

--
Have a great day!

converting text to numbers
 

shows NA if you do not have any X in a, b or c column, you can use

=if(iserror((lookup("x",a2:c2,{4,8,15}))),"",(look up("x",a2:c2,{4,8,15})))

hth

--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Marcelo" escreveu:

shows NA if you do not have any X in a, b or c column, you can use

=if(iserror((lookup("x",a2:c2,{4,8,15}))),"",(look up("x",a2:c2,{4,8,15})))

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"northerner" escreveu:

Marcelo,
I tried that and it displays NA. Any other suggestions?
--
Have a great day!


"Marcelo" wrote:

Hi,

see if it helps you

on F2
=lookup("x",a2:c2,{4,8,15})

hth

--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"northerner" escreveu:

I have columns "A", "B", and "C". I want to place an "X" in only one of the
cells in the row below. If x is in column "A", it will =4. If x is in column
"B", it will =8. If x is in column "C", it will =15. How do I create this
formula so that whatever x equals, that number will be displayed in cell F2?

Thanks in advance,

--
Have a great day!