converting text to numbers

N

northerner

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?
I tried =lookup("x",a2:c2,{4,8,15}), but it displayed NA
Does anyone have any help?
Thank you
 
M

Marcelo

see your previous post

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



"northerner" escreveu:
 
M

Marcelo

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}))),"",(lookup("x",a2:c2,{4,8,15})))

hth

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



"Marcelo" escreveu:
 
M

Marcelo

thanks for the feedback

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



"northerner" escreveu:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

converting text to numbers 4
Help With Searching For Strings In Part Numbers 3
Excel Help with dates 2
Scrabble Value calculation for Welsh words 0
lookup second / last match with two conditions 1
Cumlative Counting Question 4
Determine if a month falls between two dates. 5
Copying formulas across columns 2

Top