Posted to microsoft.public.excel.worksheet.functions
|
|
VLookup & Case Sensitivity
thanks, worked perfectly!
--
K Hogwood-Thompson
"starguy" wrote:
try this
=IF(EXACT(K4,VLOOKUP(K4,I5:J11,1,FALSE)),VLOOKUP(K 4,I5:J11,2,FALSE))
change references accordingly.
KHogwood-Thompson Wrote:
Hi All,
I am trying to compare two spreadsheets of text strings, I only want to
find
those that match content and case. Currently Excel says that they match
even
if the case is not matching ie
Follow Up is not the same as Follow up
But with my current standard vlookup statement, Excel returns these
values
as matching.
Please can someone help.
Thanks
--
K Hogwood-Thompson
--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=570257
|