| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Returning a value based on a query
Hi.
What function would I use to look for specific text in a cell, i.e. Rescind or Cancel, and return the value R or C in a designated cell? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Returning a value based on a query
Hi,
If the cell could contain anything try this =IF(A1="Rescind","R",IF(A1="Cancel","C","")) If it will only contain Rescind or Cancel try this =LEFT(A1,1) Mike "Gail" wrote: Hi. What function would I use to look for specific text in a cell, i.e. Rescind or Cancel, and return the value R or C in a designated cell? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Returning a value based on a query
Thanks. I'll try that. Have a good one!
"Mike H" wrote: Hi, If the cell could contain anything try this =IF(A1="Rescind","R",IF(A1="Cancel","C","")) If it will only contain Rescind or Cancel try this =LEFT(A1,1) Mike "Gail" wrote: Hi. What function would I use to look for specific text in a cell, i.e. Rescind or Cancel, and return the value R or C in a designated cell? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Returning a value based on a query
HI.
The cell I want to do the query on contains other data. I want to find the text "Rescind" and return the "R" value. What is the best function to use? Gail "Mike H" wrote: Hi, If the cell could contain anything try this =IF(A1="Rescind","R",IF(A1="Cancel","C","")) If it will only contain Rescind or Cancel try this =LEFT(A1,1) Mike "Gail" wrote: Hi. What function would I use to look for specific text in a cell, i.e. Rescind or Cancel, and return the value R or C in a designated cell? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Returning a value based on a query
Maybe this
=IF(ISNUMBER(SEARCH("Rescind",A1)),MID(A1,SEARCH(" Rescind",A1),1),IF(ISNUMBER(SEARCH("Cancel",A1)),M ID(A1,SEARCH("Cancel",A1),1),"")) Mind the line wrap, its all on one line. Mike "Gail" wrote: HI. The cell I want to do the query on contains other data. I want to find the text "Rescind" and return the "R" value. What is the best function to use? Gail "Mike H" wrote: Hi, If the cell could contain anything try this =IF(A1="Rescind","R",IF(A1="Cancel","C","")) If it will only contain Rescind or Cancel try this =LEFT(A1,1) Mike "Gail" wrote: Hi. What function would I use to look for specific text in a cell, i.e. Rescind or Cancel, and return the value R or C in a designated cell? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Returning a value based on a query
Try this:
=IF(COUNTIF(A1,"*cancel*"),"C",IF(COUNTIF(A1,"*res cind*"),"R","")) -- Biff Microsoft Excel MVP "Gail" wrote in message ... HI. The cell I want to do the query on contains other data. I want to find the text "Rescind" and return the "R" value. What is the best function to use? Gail "Mike H" wrote: Hi, If the cell could contain anything try this =IF(A1="Rescind","R",IF(A1="Cancel","C","")) If it will only contain Rescind or Cancel try this =LEFT(A1,1) Mike "Gail" wrote: Hi. What function would I use to look for specific text in a cell, i.e. Rescind or Cancel, and return the value R or C in a designated cell? |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Returning a value based on a query
I also have a question related to this topic.
I need to write a forumula that identifies a cell value on a row "if <1", then to return the value of a text cell on the same row. e.g. if B2<1 then return the text value of cell C2 as the answer. Probably simple but ??? Thanks. "T. Valko" wrote: Try this: =IF(COUNTIF(A1,"*cancel*"),"C",IF(COUNTIF(A1,"*res cind*"),"R","")) -- Biff Microsoft Excel MVP "Gail" wrote in message ... HI. The cell I want to do the query on contains other data. I want to find the text "Rescind" and return the "R" value. What is the best function to use? Gail "Mike H" wrote: Hi, If the cell could contain anything try this =IF(A1="Rescind","R",IF(A1="Cancel","C","")) If it will only contain Rescind or Cancel try this =LEFT(A1,1) Mike "Gail" wrote: Hi. What function would I use to look for specific text in a cell, i.e. Rescind or Cancel, and return the value R or C in a designated cell? |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Returning a value based on a query
Try this:
=IF(B2<1,C2,"") Note that if B2 is an empty cell, an empty cell evaluates as 0 and 0 is less than 1 so the result will be the value of C2. If you don't want that to happen try this version: =IF(AND(COUNT(B2),B2<1),C2,"") -- Biff Microsoft Excel MVP "linda" wrote in message ... I also have a question related to this topic. I need to write a forumula that identifies a cell value on a row "if <1", then to return the value of a text cell on the same row. e.g. if B2<1 then return the text value of cell C2 as the answer. Probably simple but ??? Thanks. "T. Valko" wrote: Try this: =IF(COUNTIF(A1,"*cancel*"),"C",IF(COUNTIF(A1,"*res cind*"),"R","")) -- Biff Microsoft Excel MVP "Gail" wrote in message ... HI. The cell I want to do the query on contains other data. I want to find the text "Rescind" and return the "R" value. What is the best function to use? Gail "Mike H" wrote: Hi, If the cell could contain anything try this =IF(A1="Rescind","R",IF(A1="Cancel","C","")) If it will only contain Rescind or Cancel try this =LEFT(A1,1) Mike "Gail" wrote: Hi. What function would I use to look for specific text in a cell, i.e. Rescind or Cancel, and return the value R or C in a designated cell? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Returning a value in one cell based on the criteria of another cel | Excel Worksheet Functions | |||
| Returning all values based on 2 criteria... | Excel Discussion (Misc queries) | |||
| Incorrect syntax near '#' problem when returning to MS Query fromExcel | Excel Discussion (Misc queries) | |||
| Returning data to Excel sheet from MS query | Excel Discussion (Misc queries) | |||
| Returning Multiple Values Based on One Value | Excel Worksheet Functions | |||
Linear Mode
