how to add data from another sheet -vlookup

[sumesh56]

I need to append some data from another sheet using vlookup. kinldy help in solving the issue.see the attached file.thanks in advance

[FDibbins]

From your file...

I want the data from sheet named VOLT to be appended to col D of this sheet.

What data do you want returned?

Im really not sure what you are tring to accomplish with the MATCH part of your formula, that argument is supposed to be the column number?
=VLOOKUP(A2,VOLT!$B$3:$E$8,MATCH(VOLT!B$3,VOLT!$B$2:$E$2,0),0)

[JohnTopley]

This ?

=IFERROR(VLOOKUP($A2,VOLT!$B$3:$E$8,COLUMNS($A1:A1),0),"")

[sumesh56]

This ?

=IFERROR(VLOOKUP($A2,VOLT!$B$3:$E$8,COLUMNS($A1:A1),0),"")

thanks for the help.it works fine.

[sumesh56]

From your file...


What data do you want returned?

Im really not sure what you are tring to accomplish with the MATCH part of your formula, that argument is supposed to be the column number?
=VLOOKUP(A2,VOLT!$B$3:$E$8,MATCH(VOLT!B$3,VOLT!$B$2:$E$2,0),0)

thanks for giving time to my issue.