Vlookup

[Miguelluis]

Is it possible to run a VLOOKUP or other formula to compare two worksheets, then if Cell A is present in both of them return the whole row on a third sheet?

Is this possible?

 

[Andrew Poulsom]

What is 'Cell A' and which sheet's values do you want to return?

 

[Miguelluis]

I have one workbook with 3 sheets. One for outstanding, one for daily report, and one for results.
each sheet will have about 1500 with the following numbers:
[TABLE="class: grid, width: 381"]
<TBODY>[TR]
[TD="align: right"]2013-03-22-15.15.52.219000</SPAN>
</SPAN>
[/TD]
[TD]N</SPAN>
[/TD]
[TD]850[/TD]
[TD="align: right"]1</SPAN>
[/TD]
[TD="align: right"]This is now ready</SPAN>
[/TD]
[/TR]
</TBODY>[/TABLE]

I then run a report (below)that I want to match with the above but my report does not have the last column, which are notes. I want to compare the two reports and if the first cell matches (like my examples do) return the above row to the third sheet.
If theres no match like below, then return the new row to the third sheet.

If two sheets would be enough to do this it would even be better.

Hope this helps

[TABLE="class: grid, width: 500"]
<TBODY>[TR]
[TD]2013-03-22-15.15.52.219000</SPAN>
[/TD]
[TD]N[/TD]
[TD]850[/TD]
[TD]1
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2013-03-22-15.15.31.936001[/TD]
[TD]N[/TD]
[TD]860[/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]

 

[Andrew Poulsom]

Why can't you lookup the first sheet's notes column on the second sheet?

 

[Miguelluis]

the notes are manualy entered on the first sheet. The second sheet is a report that changes every day, and has no notes.

The first sheet has the outstanding items from the previous day. on the second sheet is the current day's outstanding items, what I want is to be able to show the previos days work plus any new work without changing the notes that have been added.