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!
