What I want to do
I need to validate, if sheet1 data is present in sheet 2
Ex: check if IBM.N with value 52.35 is present in sheet2
Thanks in Advance
=countifs(Sheet2!A:A, A2, Sheet2!B:B, B2)>0
=vlookup(A2, Sheet2!A:B, 2 false)=B2
Credits:JNevill