Quick Links ▼

Bookmark page

Printable version

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

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

	98.1 % recommend us
	More live stats...

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

Training information:

excel-training-courses - Lookups

Resolved · Low Priority · Version Standard

Reply Mon 15 Oct 2007, 16:17Delegate Rebecca said...

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

For upcoming training course dates see: Pricing & availability

Reply Thu 18 Oct 2007, 10:29Delegate Paul said...

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

Reply Tue 23 Oct 2007, 10:09Trainer Richard said...

RE: Lookups

Thanks Paul.

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

Many thanks

Richard

Excel articles

· How Small Businesses Profit from Outside Excel Training
· Microsoft Excel Cheat Sheet: Tips and Shortcuts
· Replacing Cell Formats In An Entire Excel Workbook
· Why Should I Learn Visual Basic in Excel?
· How Getting Together Is Now Even Easier With Excel

Excel tip:

The Easiest Way to See a Sum or Average in Excel 2010

Did you know the quickest and most simple way of working out the average or sum of a set of numbers?

Highlight numbers in cells or type some numbers in cells and then look at the status bar at the bottom of the window. Here you will see a display of the average of the numbers, as well as a count of the cells and the sum of these cells.

View all Excel hints and tips