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

wrote:

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