Mark Y/N if text appears in another column

**KMorris10** · 04-05-2012, 09:56 AM

I need to mark Y/N in column G if the text from column A appears in column C of another page. What is the best way to do this?

**jraj1106** · 04-05-2012, 09:59 AM

Hi
can you upload a sample file

**KMorris10** · 04-05-2012, 10:09 AM

Test.xls

I hope that attachment worked. Basically, column 1 on page 1 shows a list of POs. The second page shows from that list, what has shipped. So I need column 2 to say Y if shipped (appears on page 2) or N if not shipped (does not appear on page 2).

**zbor** · 04-05-2012, 10:16 AM

Here, try this:

It's a array formula so must be entered by ctrl+shift+enter

**KMorris10** · 04-05-2012, 10:23 AM

I'm going to be building on this daily. At the end I will have somewhere around 700 call #'s and the values in page 2 will be pasted from SAP. Is there anyway the Y/N column on page 1 can auto-populate once the values are pasted from SAP on page 2?