Index collect from

Ramiel Merete

I have 2 sheets I am working on with;

1. Sheet #1 (POD Archive) - this is where the entries are logged. A single entry could have multiple PO's in column "PO Number". PO numbers were separated by space.
2. Sheet #2 (POV) - contains data imported from an external application using Excel - it contains one PO number per record entry.

How can I populate column "POD Entries" in Sheet #2 (POV) if po number is found in Sheet #1 (POD Archive) column "PO Number" and if the number doesn't exist then it will say "No Match"?

Thanks in advance.

DKazatsky2

Hi @Ramiel Merete,

Try this.

=IF(CONTAINS([PO_NBR]@row, {PO Number}), "Found", "No Match")

You didn't say what you wanted to show for a match, so substitute that for "Found".

Hope this helps,

Dave

DKazatsky2

@Ramiel Merete

This should do the trick.

=IF(CONTAINS([PO_NBR]@row, {PO Number}), [PO_NBR]@row, "No Match")

Ramiel Merete

Genevieve P.

Paul Newcome

DKazatsky2

Hi @Ramiel Merete,

Try this.

=IF(CONTAINS([PO_NBR]@row, {PO Number}), "Found", "No Match")

You didn't say what you wanted to show for a match, so substitute that for "Found".

Hope this helps,

Dave

Ramiel Merete

@DKazatsky2

Hi Dave - sorry I forgot to mention - it should show whatever PO Number matches the PO_NBR in Sheet #2.

Thanks.

DKazatsky2

@Ramiel Merete

This should do the trick.

=IF(CONTAINS([PO_NBR]@row, {PO Number}), [PO_NBR]@row, "No Match")

Ramiel Merete

Thanks, Dave. Worked perfectly!