VLook Up/Pivot

Resolved · Low Priority · Version 2010

Thu 15 Dec 2016, 11:24 Delegate Sophie said...

Sophie has attended:
Excel Advanced course

VLook Up/Pivot

Hi Martyn

Question 1
Is there anyway to V Look Up images. I have a master product sheet where the images relate to the product codes. I can sort and filter and they stay in the right place which makes me think they are embedded into the cell?

Ideally I want to be able to move the selection over to a new spreadsheet.

Question 2
I have a spreadsheet that I export form our accounts system, it tells me all overdue invoices by line (so one account can have 20 overdue invoices so 20 lines). I then turn it into a pivot table so I get a total amount summary by account. I then make a new tab with the notes per account and Vlook up into the column next to the pivot. I then want to filter things around and have the notes follow the pivot, is that possible? It is hard to explain over email! Maybe I can send directly to you to look at if it is not clear?

Thank you

Sophie Robb

Mon 19 Dec 2016, 12:28 Trainer Doug said...

RE: VLook Up/Pivot

Hi Sophie

Thanks for both questions.

It might help to send your files for your questions if possible.
Send to info@stl-training.co.uk and ask to forward to me

Thanks

Doug Dunn
STL

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Formula for last day of month

In some cases it is necessary to find the last day of a month for a given date. If you use the following formula, you can achieve this, ie; if you have a column of dates, use this formula to find the end of month for each day by using the fill handle. The formula is as follows, and assumes in this example that the first date in question is in cell C5, in any other cell type; =DATE(YEAR(C5),MONTH(C5)+1,1)-1

View all Excel hints and tips