Case-sensitive VLOOKUP in Excel

[Freeman2022]

Hello,

I'm currently using excel 365, I'm trying to find a "look up" formula that will recognize text case.

 

[AhoyNC]

Try:

Book2
	A	B	C	D	E
1	Item		price
2	0031W00002j4DSH		$5.00		0036S00005hbLhQ
3	0034000000nUJCG		$6.00		8
4	0036S00005hbLhq		$7.00
5	0036S00005hbLhQ		$8.00
Sheet2

Cell Formulas
Range	Formula
E3	E3	=FILTER(C2:C5,ISNUMBER(FIND(E2,A2:A5)),"No Match")

 

[JoeMo]

Another way:

Book1
	A	B	C	D	E
1	Item		price
2	0031W00002j4DSH		5		0036S00005hbLhQ
3	0034000000nUJCG		6		8
4	0036S00005hbLhq		7
5	0036S00005hbLhQ		8
Sheet5

Cell Formulas
Range	Formula
E3	E3	=INDEX(A2:C5,MATCH(TRUE, EXACT(E2, A2:A5), 0),COLUMNS(A1:C1))

 

[Freeman2022]

Thank you both!!!! Both formulas worked!!!!

 

[AhoyNC]

You're welcome, glad we helped. Thanks for the feedback.