BeerBeer101
New Member
- Joined
- Dec 29, 2021
- Messages
- 35
- Office Version
- 365
- Platform
- Windows
this one should be simple, but i'm having a brain fart I think:
Formula for F2: If E2 matches value in A2:A20, return value in B2:B20.
the value in B2 will always be the same for each "client" and it is in fact returning a date - i just can't seem to think of what the start should be.
=XXXXX(E2=$A$2:$A$20, $B$2:$B$20, 0)
thanks as always!
Formula for F2: If E2 matches value in A2:A20, return value in B2:B20.
the value in B2 will always be the same for each "client" and it is in fact returning a date - i just can't seem to think of what the start should be.
=XXXXX(E2=$A$2:$A$20, $B$2:$B$20, 0)
thanks as always!