FORMULA FOR CATEGORIES

[punit83]

NEED FORMULA TO CATEGORIES FROM DATA.

IN COLUMN A DATA ARE THERE WITH THIS DETAIL IN IT AND I WANT TO CATEGORIES IN COLUMN B.
PLS HELP WITH FORMULA I TRIED WITH IFS, SEARCH BUT GETTING ERROR.

Book1
	A	B
1	INV AB 001-24-25	INV
2	PAYMENT RECEIVED	PAYMENT
3	RECEIVED MATERIAL	MATERIAL
4	PART PAYMENT	PART
Sheet1

THANKS IN ADVANCE.

 

[punit83]

Try:

Book1
	A	B	C	D
1	INV AB 001-24-25 Dated :XX-XX-XXXX	INV		INV
2	PAYMENT RECEIVED FOR INV # AB	PAYMENT		PAYMENT
3	RECEIVED MATERIAL FOR PROJECT X	MATERIAL		MATERIAL
4	PART PAYMENT	PART		PART
Sheet2

Cell Formulas
Range	Formula
B1:B4	B1	=LET(s,SEARCH($D$1:$D$4,A1),XLOOKUP(MIN(IF(ISNUMBER(s),s)),s,$D$1:$D$4))

THANK YOU SO MUCH, WORKED FOR ME......