Solved

formula to find exact match excel

Posted on 2011-02-15
1
474 Views
Last Modified: 2012-05-11
hy,
have workbook with 2 sheets , in sheet1 is data downloaded from web in sheet2 are formulas puling data from sheet1,
issue is when in sheet1 two different data  are almost the same then formula in sheet2 doesn't recognize differences between data (big and small letters)

is there formula to find exact match

workbook in attachment
Book95.xls
0
Comment
Question by:thmh
1 Comment
 
LVL 50

Accepted Solution

by:
barry houdini earned 100 total points
ID: 34896422
In general if you do a comparison between two values like A1=B1 then that isn't case-sensitive so you need to use EXACT function for that, i.e.

=EXACT(A1,B1)

so using EXACT your formula in AN136 would become

=IFERROR(IF($AL136="","",LOOKUP(2,1/(EXACT($AL136&"",LEFT(Temp!$M$18:$M$31,4))*EXACT($AM136&"",LEFT(TRIM(REPLACE(Temp!$M$18:$M$31,1,FIND("-",Temp!$M$18:$M$31),"")),4))),Temp!P$18:P$31)),1)

regards, barry
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question