|
| 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
May 12th, 2010, 03:58 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF formula help?
Hi, can anyone help me write an IF statement? I have a list of names in
Column A and want to check it against another list of names in Column D - if the name matches one of the names in Column D I'd like it to put a Y in Column B. I tried =IF(A2,VLOOKUP($D$2:$D$1631,"Y","N")) but it doesn't work. -- Thank you in advance!!!! 
|
|
#2
May 12th, 2010, 04:12 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF formula help?
daisy wrote:
Hi, can anyone help me write an IF statement? I have a list of names in Column A and want to check it against another list of names in Column D - if the name matches one of the names in Column D I'd like it to put a Y in Column B. I tried =IF(A2,VLOOKUP($D$2:$D$1631,"Y","N")) but it doesn't work. Try looking in the help file for the proper format for the IF and VLOOKUP functions... IF( logical_test , value_if_true , value_if_false ) VLOOKUP( lookup_value , table_array , col_index_num , range_lookup ) I think this will work for your needs: =IF(ISERROR(VLOOKUP(A2,$D$2:$D$1631,1,FALSE)),"N", "Y")
|
|
#3
May 12th, 2010, 04:33 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF formula help?
Here's one way...
=IF(COUNTIF(D$2  $1631,A2),"Y","N")-- Biff Microsoft Excel MVP "daisy" wrote in message ... Hi, can anyone help me write an IF statement? I have a list of names in Column A and want to check it against another list of names in Column D - if the name matches one of the names in Column D I'd like it to put a Y in Column B. I tried =IF(A2,VLOOKUP($D$2:$D$1631,"Y","N")) but it doesn't work. -- Thank you in advance!!!!
|
|
#4
May 12th, 2010, 04:36 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF formula help?
Copy and paste the below formula in B2 cell.
=IF(A2="","",IF(ISNUMBER(COUNTIF(D ,A2)),"Y","N") )Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "daisy" wrote: Hi, can anyone help me write an IF statement? I have a list of names in Column A and want to check it against another list of names in Column D - if the name matches one of the names in Column D I'd like it to put a Y in Column B. I tried =IF(A2,VLOOKUP($D$2:$D$1631,"Y","N")) but it doesn't work. -- Thank you in advance!!!!
|
|
#5
May 12th, 2010, 05:16 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF formula help?
thanks everyone -
 -- Thank you in advance!!!! "Glenn" wrote: daisy wrote: Hi, can anyone help me write an IF statement? I have a list of names in Column A and want to check it against another list of names in Column D - if the name matches one of the names in Column D I'd like it to put a Y in Column B. I tried =IF(A2,VLOOKUP($D$2:$D$1631,"Y","N")) but it doesn't work. Try looking in the help file for the proper format for the IF and VLOOKUP functions... IF( logical_test , value_if_true , value_if_false ) VLOOKUP( lookup_value , table_array , col_index_num , range_lookup ) I think this will work for your needs: =IF(ISERROR(VLOOKUP(A2,$D$2:$D$1631,1,FALSE)),"N", "Y") .
|
|
#6
May 12th, 2010, 05:25 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF formula help?
Correction to my previous post.
=IF(A2="","",IF(COUNTIF(D ,A2)0,"Y","N"))-------------------- (Ms-Exl-Learner) -------------------- "Ms-Exl-Learner" wrote: Copy and paste the below formula in B2 cell. =IF(A2="","",IF(ISNUMBER(COUNTIF(D ,A2)),"Y","N") )Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "daisy" wrote: Hi, can anyone help me write an IF statement? I have a list of names in Column A and want to check it against another list of names in Column D - if the name matches one of the names in Column D I'd like it to put a Y in Column B. I tried =IF(A2,VLOOKUP($D$2:$D$1631,"Y","N")) but it doesn't work. -- Thank you in advance!!!!
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
