View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Trying to match up variables to a common list and confirm

Hi, Try this,

Finding a word from list in column B6-b130 to match word in A6. If there is a
match then place "x" in column AB6 - No match leave AB6 Blank.
then right on down the line:



=IF(B6=A$6,"x","")

Put this formula in AB6 and drag down to AB130

You other questions can be solved with this formula with the ranges modified.

Mike



"DebKnight56" wrote:

Finding a word from list in column B6-b130 to match word in A6. If there is a
match then place "x" in column AB6 - No match leave AB6 Blank.
then right on down the line:
Finding a word from list in column B6-b130 to match word in A7. If there is
a match then place "x" in column AB7 - No match leave AB7Blank.
Finding a word from list in column B6-b130 to match word in A8. If there is
a match then place "x" in column AB8 - No match leave AB8 Blank,
And so on.
Help new on job and short time! Thx anyone!