Pizzaman22
New Member
- Joined
- Apr 18, 2021
- Messages
- 13
- Office Version
- 365
Hello, I was looking for help on how to match the following
A. B. C.
Address | House Items | Received item
123john_street | Spoon | Yes
123john_street. | Fork. | Yes
123john_street | Knife | Yes
255john_street. | Apron. | No
So, what I need it’s to do is
Only Exact match “123john” so the first (6 characters) and if already the exact “address” took any items from “house items” previously then provide a “yes” or “no” value in the “received item” Column.
Any help would be great! Thanks!
A. B. C.
Address | House Items | Received item
123john_street | Spoon | Yes
123john_street. | Fork. | Yes
123john_street | Knife | Yes
255john_street. | Apron. | No
So, what I need it’s to do is
Only Exact match “123john” so the first (6 characters) and if already the exact “address” took any items from “house items” previously then provide a “yes” or “no” value in the “received item” Column.
Any help would be great! Thanks!