![]() |
Using VLookup, how can I retireve the related columns.
|
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 |
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