if statement
 

I have two sheets with over 35K rows. ( sheet1 =data & Sheet2 = Records)

I want an if statement similar to the Vllookup function..

If
Sheet1 A: A. record A1 = Sheet 2 b:B
copy that row in sheet 2 and paste it in sheet 1 ( next to that particular
cell)

next A2

Pls help

if statement
 

try doing a query on a third sheet
you'll find it in Data menu