cross Referencing Cells

[paxodiva]

Hi All
Could someone please help a hopeless case?
I have a worksheet that has data in column A B & C as below

<TABLE style="WIDTH: 135pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=179 x:str><COLGROUP><COL style="WIDTH: 19pt; mso-width-source: userset; mso-width-alt: 914" width=25><COL style="WIDTH: 58pt; mso-width-source: userset; mso-width-alt: 2816" span=2 width=77><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 19pt; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=20 width=25>BE</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 58pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl66 width=77 align=right x:num>435152877</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 58pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl66 width=77 align=right x:num>435158876</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=20>BG</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" align=right x:num="550053028">550053028</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" align=right x:num="550063027">550063027</TD></TR></TBODY></TABLE>

and data in Columns L M & N

<TABLE style="WIDTH: 178pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=238 x:str><COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 3181" span=2 width=87><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl66 height=20 width=64>BG</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 65pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl67 width=87 align=right x:num="549714108">549714108</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 65pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl67 width=87 align=right x:num="549714542">549714542</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl66 height=20>IT</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 65pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl67 width=87 align=right x:num="2810274752">2810274752</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 65pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl67 width=87 align=right x:num="2810278751">2810278751</TD></TR></TBODY></TABLE>

I need somehow to cross reference what is in L M & N back to A B & C
and if there are any that are the same then have the fields Highlighted

 

[paxodiva]

Hi All
Please is there anyone out there that can help me with my problem

 

[BGY23]

What do you want to do check that all 3 cells match or just that certain cells match ?

What if they don't match ? What if only one matches ?

Use conditional formatting to get the colour to change

 

[paxodiva]

Sorry , I havnt explained myself very well

If Cells L1 M1 & N1 are anywhere in column A B C
then highlight the fact that they are available in both
sections
A B C
IE BA 666666 666666

L M N
NA 222222 222222
BA 666666 666666

I hope this makes more sense
really sorry I am new to all of this

 

[BGY23]

Use conditional formatting with a vlookup.

Assuming you are checking A to L; B to M and C to N then Highlight your data in column A then

On the menu bar Format>Conditional formatting?
In the pop up box change cell value is to Formula
in the formula bar type

=VLOOKUP($A3,$L$3:$L$5,1,0) (Alter the ranges to suit your data)

When it finds a match the format you set will highlight the cell. If the reference isn't in Col L it will remain unformatted.
Do the same for each column as required.

 

[paxodiva]

Thank you very very much for your reply
however i have not built a Vlookup before and am unsure what to do

could you please assist or advise on where i can get help
i have tried using excel help but does not explain very well

 

[paxodiva]

Hi everyone

I am still struggling to understand this VLOOKUP as i need to cross reference across all 3 cells but do not appear to be able to get thisto work

I require columns ABC to cross reference against LMN

so if ABC = BA 521521 521521 and columns LMN = BA 521521 521521
then this would be a match and so would be highlighted
however if it was

BA 521521 521521 & BA 666666 666666
this would not be a match so would not be highlighted
hope this makes sense and look forward to hearing from you all

 

[BGY23]

What your now saying is that all 3 cells in abc have to be exactly the same as all 3 cells in LMN ?

If so are you just cecking on a row basis or anywhere in the 3 columns abc to anywhere in the 3 columns lmn.?

i.e. are you lookng at a1:c1 in L1:n1 or anywhere in columns L to N?

 

[paxodiva]

If the rows in LMN are in any rows from ABC:1 to ABC:66

 

[paxodiva]

any help would be very much appreciated