ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Using VLookup, how can I retireve the related columns. (https://www.excelbanter.com/excel-programming/416564-using-vlookup-how-can-i-retireve-related-columns.html)

Mary Ann[_2_]

Using VLookup, how can I retireve the related columns.
 


[email protected]

Using VLookup, how can I retireve the related columns.
 
On Sep 4, 4:03*pm, Mary Ann <Mary
wrote:


Mary Ann, you've provided very little information. Are you trying to
use VLookup programmatically or in a formula? The Excel Help
documentation on VLookup is pretty good if using it in a formula.

Regards,

Steven

Dave Peterson

Using VLookup, how can I retireve the related columns.
 
You may want to use =index(Match()).

Debra Dalgleish has lots of notes on =vlookup() and =index(match()) he
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))
and
http://contextures.com/xlFunctions02.html#Trouble



Mary Ann wrote:

--

Dave Peterson


All times are GMT +1. The time now is 11:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com