Grouping/Sub totalling then VLookup

Hello Tashi,

You cannot use the vlookup to extract the subtotals, this would require more development. however, send me a sample sheet with what you have done so far and what you want to achieve and i'll have a look to see if there is a non development way of doing this.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Mark
Microsoft Office Specialist Trainer