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