Vlookup and return a value for match, no match items

[jschoon4]

I am currently matching a Unit of Measure (UOM) on Spreadsheet 1 compared to UOM on spreadsheet two.

Column A is the item number, Column B is the OUM & Column C is the Vlookup return Value on Sheet 1

On sheet 2 Column A is the item number, Column B is the OUM

I am using Vlookup to do a side by side comparison which I have done the result on column C. I would to have in Column D tell me if that the UOM is a Match or No Match. MY current Sheet 1 Column C Vlookup Function is =VLOOKUP(B2,Sheet2!$A$2:$B$1397,2,0). I made a example of what I am looking for. For this example the cell may not match my actual Vlookup funtion.

A</SPAN>	B</SPAN>	C</SPAN>	D</SPAN>
Item#</SPAN>	UOM</SPAN>	UOM Comparison</SPAN>	Match/No Match</SPAN>
34654</SPAN>	EA</SPAN>	CA</SPAN>	No Match</SPAN>

<TBODY>
</TBODY>

 

[hippiehacker]

in D2

=if(B2=C2,"Match","No Match")

 

[jschoon4]

Thanks! That did it

 

[hippiehacker]

Thanks! That did it

or without the requirements of Column C

=if(B2=VLOOKUP(B2,Sheet2!$A$2:$B$1397,2,0),"Match","No Match")