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 » excel-training-courses - Lookups
excel-training-courses - Lookups
Resolved · Low Priority · Version Standard
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
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
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
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:Editing Formulas in Excel CellsAlthough people like to edit a formula in the Formula bar, you can also edit a formula in the cell. |
