Pull Data

[PrakashGunabalan]

i want pull the jan month data to sheet 2, xlookup & filter function is available in system

can someone help out with alternate excel formula

Sales Month	Product	Location
Jan	Product1	Location 1
Jan	Product1	Location 1
Jan	Product2	Location 2
Jan	Product2	Location 2
Jan	Product1	Location 3
Feb	Product1	Location 1
Feb	Product1	Location 1
Feb	Product2	Location 2
Feb	Product2	Location 2
Feb	Product1	Location 3
Mar	Product2	Location 2
Mar	Product2	Location 2
Mar	Product1	Location 3
Mar	Product1	Location 1
Mar	Product1	Location 1

 

[Alex Blakenburg]

Is the date column an actual date or is it Text ?
If its a date are they individual dates or all the 1st of the month.

eg for Dates

=FILTER(Sheet1!A2:C100,Sheet1!A2:A100=DATE(2025,1,1),"None")

for text

=FILTER(Sheet1!A2:C100,Sheet1!A2:A100="Jan","None")