98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » VLook Up/Pivot
VLook Up/Pivot
Resolved · Low Priority · Version 2010
Thu 15 Dec 2016, 11:24Delegate 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:28Trainer 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 information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Formula for last day of monthIn 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 |
