Wad Mabbit
Board Regular
- Joined
- Mar 31, 2016
- Messages
- 74
- Office Version
- 2016
- Platform
- Windows
Hi,
I have an INDEX and MATCH for the next appointment of a customer, using an extracted phone number as ID.
Dates are in B, times are in C, ID (a phone number) is in L
This works for for a next single applintment...
=if(L5="" , "",IFNA(LEFT(text(INDEX(B6:B$1559,MATCH(L5,L6:L$1559,0)),"dddd"), 3),"") & IFNA(text(INDEX(B6:B$1559,MATCH(L5,L6:L$1559,0)), " d/m"),"") &
" at " &
IFNA(INDEX(C6:C$1559,MATCH(L5,L6:L$1559,0)),"") )
giving:
Wed 14/9 at 8:45-10:45
Is there a way to get a list of all future appointments?
I have an INDEX and MATCH for the next appointment of a customer, using an extracted phone number as ID.
Dates are in B, times are in C, ID (a phone number) is in L
This works for for a next single applintment...
=if(L5="" , "",IFNA(LEFT(text(INDEX(B6:B$1559,MATCH(L5,L6:L$1559,0)),"dddd"), 3),"") & IFNA(text(INDEX(B6:B$1559,MATCH(L5,L6:L$1559,0)), " d/m"),"") &
" at " &
IFNA(INDEX(C6:C$1559,MATCH(L5,L6:L$1559,0)),"") )
giving:
Wed 14/9 at 8:45-10:45
Is there a way to get a list of all future appointments?