View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] scotty.dean@tmcaz.com is offline
external usenet poster
 
Posts: 1
Default Thank you for sharing - VLOOKUP array

Hello Folks - well, I thought I was pretty good, but I see that there
are some true pros on this list - getting the answer to a long held
question inspired me to join the Group for future references sake. So,
a big thank you to all for sharing your knowledge - my specific issue
was having a VLOOKUP look across a data set of 35 columns and return
the answer, without having to individually adjust each new equation for
the next column reference, so a direct thank you to Excel MVP Thomas
Ogilvy for the direction on using an array.
Scotty Dean - Director, Forecasting - Tucson Medical Center