Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need a search/find/lookup function
I need a function to determine if value "A" exists in range B1:B10. If A
exists in B1:B10, return "C". If A doesn't exist in B1:B10, return "D." I have tried using lookup, I've tried index and match, I've tried search/find. I can't make any of those do what I want it to. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need a search/find/lookup function
Try something like this...
=IF(COUNTIF(B1:B10,"A"),"C","D") -- Biff Microsoft Excel MVP "Jenn" wrote in message ... I need a function to determine if value "A" exists in range B1:B10. If A exists in B1:B10, return "C". If A doesn't exist in B1:B10, return "D." I have tried using lookup, I've tried index and match, I've tried search/find. I can't make any of those do what I want it to. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need a search/find/lookup function
On Fri, 5 Feb 2010 18:03:01 -0800, Jenn wrote:
I need a function to determine if value "A" exists in range B1:B10. If A exists in B1:B10, return "C". If A doesn't exist in B1:B10, return "D." I have tried using lookup, I've tried index and match, I've tried search/find. I can't make any of those do what I want it to. Case insensitive: =IF(COUNTIF(B1:B10,"*A*"),"C","D") Case sensitive: =IF(SUMPRODUCT(--ISNUMBER(FIND("A",B1:B10))),"C","D") --ron |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need a search/find/lookup function
=IF(COUNTIF(B2:B11,"A")=1,"C","D")
OR =IF(ISNA(VLOOKUP("A",B2:B11,1,FALSE)),"D",IF(VLOOK UP("A",B2:B11,1,FALSE)="A","C","D")) OR =IF(ISNUMBER(MATCH("A",B2:B11,0)),"C","D") Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "Jenn" wrote: I need a function to determine if value "A" exists in range B1:B10. If A exists in B1:B10, return "C". If A doesn't exist in B1:B10, return "D." I have tried using lookup, I've tried index and match, I've tried search/find. I can't make any of those do what I want it to. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need a search/find/lookup function
=CHAR(68-(COUNTIF(B1:B10,"A")0))
"Jenn" wrote: I need a function to determine if value "A" exists in range B1:B10. If A exists in B1:B10, return "C". If A doesn't exist in B1:B10, return "D." I have tried using lookup, I've tried index and match, I've tried search/find. I can't make any of those do what I want it to. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search / Find Function | Excel Worksheet Functions | |||
Find / Search Function | Excel Discussion (Misc queries) | |||
Search, find or lookup defined text in text string | Excel Worksheet Functions | |||
Find & Search Function | Excel Worksheet Functions | |||
HOW TO USE FIND OR SEARCH FUNCTION TO FILL DATA | Excel Worksheet Functions |