Formula referencing another sheet

dryj

Hi all - new to formulas. This is what I'm trying to do...

Sheet A: has list of all members

Sheet B: has requests from anyone, not just members.

We want to have B look at A and if a request is from a member, it states on Sheet B that yes this person is a member so they should get the discount for their request.

So I need it to look to see if the person's name is on Sheet A and return back saying Yes or No.

Is this an "If" formula? Index?

Any help is appreciated!

Paul Newcome

Try something like this:

=IF(HAS({Sheet A Name Column}, [Name Column]@row), "Yes", "No")