if elseif
 

I want to write a If else macro to do the following replacemtn for Vlookup
(current method which takes lot of time and space)

I have two worksheets. data and acc
First row of both sheets are same but not in order.

so.. If cell data. a1 = cell A: A
then copy that row.. A: F and paste in data sheet at that cell

Help please