|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 2nd, 2010, 04:35 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup + if formula help!
I have a list of names on sheet2 (a1:a69) and if the name in cell a1 (sheet1)
matches any of those names then I want it to say "NO" in cell a2 (sheet1). if it doesn't match then I want it to say "YES" in cell a2 (sheet1). I'm assuming it is a combination of a "vlookup" and a "if" formula, but I can't right it out. Please help. 
|
|
#2
April 2nd, 2010, 04:42 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookup + if formula help!
Try this...
=IF(COUNTIF(Sheet2!A1:A69,A1),"No","Yes") -- Biff Microsoft Excel MVP "sross002" wrote in message ... I have a list of names on sheet2 (a1:a69) and if the name in cell a1 (sheet1) matches any of those names then I want it to say "NO" in cell a2 (sheet1). if it doesn't match then I want it to say "YES" in cell a2 (sheet1). I'm assuming it is a combination of a "vlookup" and a "if" formula, but I can't right it out. Please help.
|
|
#3
April 2nd, 2010, 04:51 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookup + if formula help!
Copy and paste the below formula in Sheet1 A2 cell
=IF(A1="","",IF(ISNA(VLOOKUP(A1,Sheet2!$A$1:$A$69, 1,FALSE)),"YES",IF(VLOOKUP(A1,Sheet2!$A$1:$A$69,1, FALSE)=A1,"NO",""))) Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "sross002" wrote: I have a list of names on sheet2 (a1:a69) and if the name in cell a1 (sheet1) matches any of those names then I want it to say "NO" in cell a2 (sheet1). if it doesn't match then I want it to say "YES" in cell a2 (sheet1). I'm assuming it is a combination of a "vlookup" and a "if" formula, but I can't right it out. Please help.
|
|
#4
April 2nd, 2010, 04:54 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookup + if formula help!
I have
=IF(a2=vlookup(a2,sheet1!$B$2:$B$B69,1,FALSE),"NO" , "YES") It's coming back with "NO" where it should be BUY instead of "YES" it says #N/A. What am I doing wrong, why isn't YES showing up where it should be? "sross002" wrote: I have a list of names on sheet2 (a1:a69) and if the name in cell a1 (sheet1) matches any of those names then I want it to say "NO" in cell a2 (sheet1). if it doesn't match then I want it to say "YES" in cell a2 (sheet1). I'm assuming it is a combination of a "vlookup" and a "if" formula, but I can't right it out. Please help.
|
|
#5
April 2nd, 2010, 05:01 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookup + if formula help!
I am getting an error.
I have a MAC, is that why? "sross002" wrote: I have =IF(a2=vlookup(a2,sheet1!$B$2:$B$B69,1,FALSE),"NO" , "YES") It's coming back with "NO" where it should be BUY instead of "YES" it says #N/A. What am I doing wrong, why isn't YES showing up where it should be? "sross002" wrote: I have a list of names on sheet2 (a1:a69) and if the name in cell a1 (sheet1) matches any of those names then I want it to say "NO" in cell a2 (sheet1). if it doesn't match then I want it to say "YES" in cell a2 (sheet1). I'm assuming it is a combination of a "vlookup" and a "if" formula, but I can't right it out. Please help.
|
|
#6
April 2nd, 2010, 05:03 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookup + if formula help!
I have
=IF(a2=vlookup(a2,sheet1!$B$2:$B$B69,1,FALSE),"NO" , "YES") why isn't YES showing up where it should be? Because: vlookup(a2,sheet1!$B$2:$B$B69,1,FALSE) Is returning the #N/A error meaning it can't find A2 in the range sheet1!$B$2:$B$B69. See my other reply for a better method. -- Biff Microsoft Excel MVP "sross002" wrote in message ... I have =IF(a2=vlookup(a2,sheet1!$B$2:$B$B69,1,FALSE),"NO" , "YES") It's coming back with "NO" where it should be BUY instead of "YES" it says #N/A. What am I doing wrong, why isn't YES showing up where it should be? "sross002" wrote: I have a list of names on sheet2 (a1:a69) and if the name in cell a1 (sheet1) matches any of those names then I want it to say "NO" in cell a2 (sheet1). if it doesn't match then I want it to say "YES" in cell a2 (sheet1). I'm assuming it is a combination of a "vlookup" and a "if" formula, but I can't right it out. Please help.
|
|
#7
April 2nd, 2010, 05:04 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookup + if formula help!
In cell B1 of Sheet1 try the formula:
=IF(ISNA(MATCH(A1,Sheet2!A:A,)),"YES","NO") Micky "sross002" wrote: I have a list of names on sheet2 (a1:a69) and if the name in cell a1 (sheet1) matches any of those names then I want it to say "NO" in cell a2 (sheet1). if it doesn't match then I want it to say "YES" in cell a2 (sheet1). I'm assuming it is a combination of a "vlookup" and a "if" formula, but I can't right it out. Please help.
|
|
#8
April 2nd, 2010, 05:12 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookup + if formula help!
THANKS!
"מיכאל (מיקי) אבידן" wrote: In cell B1 of Sheet1 try the formula: =IF(ISNA(MATCH(A1,Sheet2!A:A,)),"YES","NO") Micky "sross002" wrote: I have a list of names on sheet2 (a1:a69) and if the name in cell a1 (sheet1) matches any of those names then I want it to say "NO" in cell a2 (sheet1). if it doesn't match then I want it to say "YES" in cell a2 (sheet1). I'm assuming it is a combination of a "vlookup" and a "if" formula, but I can't right it out. Please help.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
