View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GS[_6_] GS[_6_] is offline
external usenet poster
 
Posts: 1,182
Default Trying to replace vlookup with xlookup and not using the indirect function

Sorry, my bad! I found XLOOKUP() in 365 so I'd have to play with it to figure a
solution for you. Unfortunately, I have too much on my plate right now so
hopefully our resident formula wizard will chime in to save the day!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion