Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

vlook uppivot

ResolvedVersion 2010

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

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

Excel tip:

Adding cells, Rows & columns

place your cursor on a cell, row number or column letter and use CTRL + SHIFT + + or CTRL + + depending on which + you prefer to use.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.