Hi
In H9 copied down on Sales Report
Formula:
=INDEX('Sales per Catogory'!$A$1:$AO$1000,MATCH(C9,'Sales per Catogory'!B:B,FALSE)+12,40)
Change row 1000 as appropriate
Hi
In H9 copied down on Sales Report
Formula:
=INDEX('Sales per Catogory'!$A$1:$AO$1000,MATCH(C9,'Sales per Catogory'!B:B,FALSE)+12,40)
Change row 1000 as appropriate
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks