VLOOKUP betwen sheets
In sheet 1 I have 4 columns (A is empty , B,C,D) in sheet 2 I have 3 columns (A,B,C)
I want in sheet 1 , A column (empty) use the VLOOKUP and if Bn (in sheet1)= Am (in sheet 2) write “ok” in An , else this shell still empty
sheet 1 B15=”Smith” sheet 2 A32=”Smith”
put in sheet 1 A15 =”ok”
if in sheet 2 not exist “Smith” A2 still empty
thank you for your attention