View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default converting text to numbers

thanks for the feedback

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



"northerner" escreveu:

Thank you!!!!! It worked!!!!!
--
Have a great day!


"Marcelo" wrote:

see your previous post

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

--
Have a great day!