PDA

View Full Version : =IF(J2=B2,"Match","") ???



Feebles
06-18-2016, 05:26 PM
Help with this would be appreciated please

Exactly what the header says but IF found put "Y" in D column where rows match

Text in both columns are text
Neither Column is sorted
to complicate things is that col B text has a number + space in front of text like following text


1. Single Spirit
What I am trying to say is this if J2 text = Single Spirit put Y in D column





but I need to use =MID(B2,FIND(".",B2)+1,256) or something like this I guess

Regards
Graham

JackMoorhead
06-18-2016, 07:42 PM
Hello Graham,
What are you searching for? Your code compares the value of J2 and B2. The way you wrote it, IF J2=J3, enter the string "MATCH", else enter nothing.
When I try to have code compare two values and enter a third value in another cell I first define what I am comparing first. Then I can decide whether to to use and IF, MID or an UDF.
Care to give me a little more detail, or a brief example?

Feebles
06-18-2016, 08:38 PM
Hi Jack, let me try to put this simply.
I have included a snapshot which may help
I have changed column J for another one which u will see.

Graham
16426

mdmackillop
06-19-2016, 02:44 AM
Hi Feebles
Why not post a sample workbook, rather than expecting us to replicate what you already have?

Feebles
06-19-2016, 04:17 AM
Very good idea, and here is a small attachment
Regards
Graham
Col C is hidden

mdmackillop
06-19-2016, 04:59 AM
=IF(ISNA(MATCH(TRIM(RIGHT(B2,LEN(B2)-FIND(". ",B2))),E:E,)),"","Y")

Feebles
06-19-2016, 05:57 AM
That is absolutely Brilliant
Thank you very much mdmackkillop
Appreciate it and from now on I will include a sample sheet
Regards
Graham

mdmackillop
06-21-2016, 05:49 AM
Please remember to mark your posts "Solved" using Thread Tools