I have a forumla where I'm looking up a Client name and finding all the
contacts that relate to that Client. The most contacts per Client is 8. This
formula works great, I just need it to reference R14C1 for 8 rows and then
increase to R15C1 for 8 rows, etc. I have 562 unique Clients x 8 =4496 and
I'm sure there is a way to Fill Down this formula instead of pasting it 4496
times.

Thank you!

=VLOOKUP('List of Clients'!R14C1,'List of contacts'!R2C1:R4475C[38],2,FALSE)
--
Thank you,

scrowley(AT)littleonline.com