pfchang,

try this:

=vlookup($A1,sheet1!$A:$D,COLUMN(),0)

However, beware of the COLUMN() function, it returns the column number where the formula is typed and hence is not a relative reference. If you are using it in other situations it would be wise to check what it is returning before inserting into a larger formula such as the one above.