OFFSET MATCH (WITHIN DATA VALIDATION) MISMATCH??

[Dlang]

For some reason my match is exactly 1 cell down from where it needs to start and I have not been able to figure out why.
Customer A should come up 1,2,3 but I'm Getting 2,3,4

=OFFSET('Customer Info'!$A$1,MATCH($B$1,'Customer Info'!$A:$A,0),1,COUNTIF('Customer Info'!$A:$A,$B$1))

Thank you.

 

[Fluff]

Hi & welcome to MrExcel
You need to use
=OFFSET('Customer Info'!$A$1,MATCH($B$1,'Customer Info'!$A:$A,0)-1,1,COUNTIF('Customer Info'!$A:$A,$B$1))
The match will return for A so you are then offsetting 1 row

 

[Dlang]

Thank you!

 

[Fluff]

You're welcome