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

excel-training-courses - lookups

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel-training-courses - Lookups

excel-training-courses - Lookups

ResolvedVersion Standard

Rebecca has attended:
Excel Advanced course

Lookups

I have one workbook with three worksheet within it, 2 with data and the third as a summary.

I would like to copy and paste lines from the two data sheets into the summary sheet that correlate. I would like to copy all the data from each corresponding line (which is 3 colums work of data) I believe that I have to combine the IF statement with ISERROR and VLOOKUP. I am trying to determine which lines are present in both of the two data worksheets

Can you please help me

many thanks

Becky

RE: Lookups

Hi Becky

I think you're nearly there. I would personally use something like

=IF(ISNA(VLOOKUP(B1,Sheet2!A:E,5,0),"",VLOOKUP(B1,Sheet2!A:E,5,0)))

this would return a blank if the figure you're looking for is not in the target table, otherwise display the resultant figure.

then from that, you can do a simple sort to make your sheet look nice and pretty :)

Hope this helps.
Any questions, feel free to email me - tealeaves18@hotmail.com

Paul

RE: Lookups

Thanks Paul.

If the above solution has answered the question, please will you mark this question as resolved.

Many thanks

Richard

Excel tip:

Missing Field handle

If your field handle goes missing all you need to do is go to tools > options > edit tab and then make sure that the check boxes for paste and insert buttons are checked.

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.2 secs.