OFFSET MATCH (WITHIN DATA VALIDATION) MISMATCH??

Dlang

New Member
Joined
Apr 2, 2020
Messages
2
Office Version
  1. 365
  2. 2013
Platform
  1. Windows
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.
 

Attachments

  • 1.png
    1.png
    3.8 KB · Views: 3
  • 2.png
    2.png
    4.1 KB · Views: 3

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
46,111
Office Version
  1. 365
Platform
  1. Windows
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
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
46,111
Office Version
  1. 365
Platform
  1. Windows
You're welcome
 

Watch MrExcel Video

Forum statistics

Threads
1,108,677
Messages
5,524,230
Members
409,566
Latest member
santoshsj

This Week's Hot Topics

Top