In VLOOKUP() can one "fetch" a range of columns?

[EagleOne]

2003

With VLOOKUP() I know that one can retrieve a R,C data item for the Found row.

What is the best way to retrieve a range of columnar data if the Keys match?

Conceptually i.e VLOOKUP(A1,Stars!A1:Z200, Columns 1 thru 22,False)

If not what is the best approach both with Excel and XL VBA?

TIA EagleOne

 

[EagleOne]

I should have made this point:

If a match, I would like to return all columnar data items on Sheet2 to columns in the same row but
different columns on Sheet1

 

[John C]

You really need a vlookup for each cell that will contain data (i.e.: 22
cells in each row will have data or 21 if not including the key, no matter
the order, you will need a formula for each cell).

 

[EagleOne]

I kind of figured that. This is a large w/s and I was attempting to avoid all of the
"Formula-overhead"

Thanks

 

[EagleOne]

I think what I'll do is
1) place the "found Sheet2" row-reference in a column on Sheet 2
2) return that value to Sheet1
3) then use VBA to copy/paste the resprctive Row/Cols found-range from Sheet2 to Sheet1