VLOOKUP not differentiating similar table entries

[glad_ir]

Hi,

I wonder if somebody could help me with a VLOOKUP challenge please.

I am trying to use the formula below to retrieve information from the table below but it only retrieves the content of cell D1 irrespective for which of the 4 H codes I enter in cell A1.

=vlookup(A1,C1-D4,2,FALSE)

	C	D
1	H360fd	info 1
2	H360fD	info 2
3	H360Fd	info 3
4	H360FD	info 4

Does anybody know what I'm doing wrong here / how I can get Vlookup to differentiate the similar values in the table?

Any help much appreciated!

thank you,
Iain

 

[etaf]

vlookup is not case sensitive
are you looking for a case sensitive result

i do not normally just post a link , but i think these explain in much better than i can and give examples and breakdown

MrExcel examples

VLOOKUP case-sensitive

Is there any way of doing a case-sensitive VLOOKUP? If my lookup table_array (A1:B2) contains APPLES xxx apples yyy then VLOOKUP("apples",A1:B2,2,false) returns "xxx", but I want "yyy".

www.mrexcel.com

Case Sensitive vlookup (Entire List)

I need to do a case sensitive vlookup. I found several results here which list a formula similar to this: =IF(EXACT(G4,VLOOKUP(G4,$C$4:$D$9,1,FALSE))=TRUE,VLOOKUP(G4,$C$4:$D$9,2,FALSE),"No exact match") The problem is that the formula returns "No exact match" once it finds a match without the...

www.mrexcel.com

or if you want - try a search for "case sensitive vlookup"

VLOOKUP case-sensitive

To create a case-sensitive lookup with the VLOOKUP function, you can use the EXACT function. In the example shown, the formula in G5 is: =VLOOKUP(TRUE,CHOOSE({1,2},EXACT(data[Color],F5),data[Qty]),2,0) where "data" is an Excel Table in the range B5:D16. In this configuration, VLOOKUP matches the...

exceljet.net

Different Ways to Perform a Case-Sensitive Vlookup in Excel - GeeksforGeeks

A Computer Science portal for geeks. It contains well written, well thought and well explained computer science and programming articles, quizzes and practice/competitive programming/company interview Questions.

www.geeksforgeeks.org

 

[glad_ir]

vlookup is not case sensitive
are you looking for a case sensitive result

i do not normally just post a link , but i think these explain in much better than i can and give examples and breakdown

MrExcel examples

VLOOKUP case-sensitive

Is there any way of doing a case-sensitive VLOOKUP? If my lookup table_array (A1:B2) contains APPLES xxx apples yyy then VLOOKUP("apples",A1:B2,2,false) returns "xxx", but I want "yyy".

www.mrexcel.com

Case Sensitive vlookup (Entire List)

I need to do a case sensitive vlookup. I found several results here which list a formula similar to this: =IF(EXACT(G4,VLOOKUP(G4,$C$4:$D$9,1,FALSE))=TRUE,VLOOKUP(G4,$C$4:$D$9,2,FALSE),"No exact match") The problem is that the formula returns "No exact match" once it finds a match without the...

www.mrexcel.com

or if you want - try a search for "case sensitive vlookup"

VLOOKUP case-sensitive

To create a case-sensitive lookup with the VLOOKUP function, you can use the EXACT function. In the example shown, the formula in G5 is: =VLOOKUP(TRUE,CHOOSE({1,2},EXACT(data[Color],F5),data[Qty]),2,0) where "data" is an Excel Table in the range B5:D16. In this configuration, VLOOKUP matches the...

exceljet.net

Different Ways to Perform a Case-Sensitive Vlookup in Excel - GeeksforGeeks

A Computer Science portal for geeks. It contains well written, well thought and well explained computer science and programming articles, quizzes and practice/competitive programming/company interview Questions.

www.geeksforgeeks.org

Thank you for the prompt reply.....I hadn't appreciated Vlookup isn't case sensitive and that's what I need! Thank you for the links - I'll take a look and mark and either mark as solved or be back in touch!

thanks again,
Iain

 

[glad_ir]

vlookup is not case sensitive
are you looking for a case sensitive result

i do not normally just post a link , but i think these explain in much better than i can and give examples and breakdown

MrExcel examples

VLOOKUP case-sensitive

Is there any way of doing a case-sensitive VLOOKUP? If my lookup table_array (A1:B2) contains APPLES xxx apples yyy then VLOOKUP("apples",A1:B2,2,false) returns "xxx", but I want "yyy".

www.mrexcel.com

Case Sensitive vlookup (Entire List)

I need to do a case sensitive vlookup. I found several results here which list a formula similar to this: =IF(EXACT(G4,VLOOKUP(G4,$C$4:$D$9,1,FALSE))=TRUE,VLOOKUP(G4,$C$4:$D$9,2,FALSE),"No exact match") The problem is that the formula returns "No exact match" once it finds a match without the...

www.mrexcel.com

or if you want - try a search for "case sensitive vlookup"

VLOOKUP case-sensitive

To create a case-sensitive lookup with the VLOOKUP function, you can use the EXACT function. In the example shown, the formula in G5 is: =VLOOKUP(TRUE,CHOOSE({1,2},EXACT(data[Color],F5),data[Qty]),2,0) where "data" is an Excel Table in the range B5:D16. In this configuration, VLOOKUP matches the...

exceljet.net

Different Ways to Perform a Case-Sensitive Vlookup in Excel - GeeksforGeeks

A Computer Science portal for geeks. It contains well written, well thought and well explained computer science and programming articles, quizzes and practice/competitive programming/company interview Questions.

www.geeksforgeeks.org

Thank you - this works a treat

=VLOOKUP(TRUE, CHOOSE({1,2}, EXACT(A1, C1:C4), D1:D4), 2, FALSE)

 

[etaf]

you are welcome