Pulling a name out of a columnq

Jared Pietila

I have a customer column on sheet 1 (ie. "John Doe") and a customer column on sheet two that displays there company name as well (ie. "SSS-John Doe")

On sheet one I am writing a formula to reference sheet two, so far I have =COUNTIF({PBR Customer}, FIND("John Doe", @cell) > 0)

This works but I want it to automatically pull out the name from the customer column on sheet one vs having to type it into the quotations.

Sameer Karkhanis

You can use the column name in sheet1 at row,

=COUNTIF({PBR Customer}, FIND([Column Name in Sheet 1]@row, @cell) >0)