Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Grouping/Sub totalling then VLookup

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Grouping/Sub totalling then VLookup

Resolved · Low Priority · Version 2010

Reply Tue 10 May 2011, 10:59Delegate Tashi said...

Tashi has attended:
No courses

Grouping/Sub totalling then VLookup

Hi,
If I do the subtotal/ grouping function on a spreadsheet of data and then I want to transfer the total to a new spreadsheet. I've been trying to use Vlookups but this just takes the first value, not the total I want to transfer. How would I therefore transfer the subtotal value to another spreadsheet?

Thanks

For upcoming training course dates see: Pricing & availability

Reply Wed 11 May 2011, 13:34Trainer Mark said...

RE: 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

Reply Fri 1 Jul 2011, 09:23Trainer Richard said...

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Thu 7 Jul 2011: Automatically marked as resolved.

Excel articles

· Do You Need To Upgrade From Excel 2003 to Excel 2007?
· Advanced Excel and PivotTable Reports
· How To Pick The Best Chart Type In Excel
· How To Use Functions In Excel 2010
· How To Make Excel Open A Particular File When It Launches

Please browse our web site to find out more about
microsoft+excel+training+course and other Microsoft training courses.

Excel tip:

Creating a range of monthly payments as text

You could use a formula to create a range of payment ie. payment amount for x% to y% rate with fixed terms and principle.

The text that would be "between Xamount and Yamount".

Here is how to do it.

1 Use the PMT function to get your monthly payments figure or whatever frequency of payments that you choose he start range.

See PMT under Excel Help

2. Nest these in the ROUND function to round decimals see ROUND under Excel Help

3. Concatenate this using "&" and concatenate " to " and concatenate "Between ".

4. Concatenate the above to PMT function for the end range

ie.

="Between "&ROUND((PMT1),decimal places)&" and "&ROUND((PMT2),decimal places)

View all Excel hints and tips