Thread: In VLOOKUP() can one "fetch" a range of columns?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] EagleOne@discussions.microsoft.com is offline
external usenet poster
  
Posts: 391
Default In VLOOKUP() can one "fetch" a range of columns?
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
Reply With QuoteReply With Quote