Using Vlookup

[bradjedis]

Greetings!

Is it possible when setting up a vlookup, to pull ALL the data for the item being queried, at one time?

ex: I look for D123, and It has 10 columns, I would like to pull the remaining nine across to the target sheet.


THanks,
Brad

[HansV]

You can either use formulas such as

=VLOOKUP("D123", 'Other Sheet'!$A$2:$J$1000, 2, FALSE)
=VLOOKUP("D123", 'Other Sheet'!$A$2:$J$1000, 3, FALSE)
...
=VLOOKUP("D123", 'Other Sheet'!$A$2:$J$1000, 10, FALSE)

in 9 adjacent columns, or, if the formulas are in columns B to J:

=VLOOKUP("D123", 'Other Sheet'!$A$2:$J$1000, COLUMN(), FALSE)

[bradjedis]

Thanks!