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