Page# Return off lookup
start with
=Match([Car Type],F1:f25000,0)/60
assumes 60 entries per page. Adjust to fit your actual situation.
--
Regards,
Tom Ogilvy
"FASTWRX" wrote:
I'm building a table of contents for a parts catalog and would like to the
page number returned off a lookup through a specific column. As I would see
it, the lookup would be somethink like this: (car type would be in TOC)
vlookup([Car Type],F2:f25000,PageNumber())
I have a problem with getting the PageNumber the item falls on to be
returned. Any ideas? TIA
|