Miguelluis

New Member
Joined
Jan 29, 2013
Messages
45
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?
 

Some videos you may like

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

Miguelluis

New Member
Joined
Jan 29, 2013
Messages
45
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:
2013-03-22-15.15.52.219000</SPAN>
</SPAN>
N</SPAN>
8501</SPAN>
This is now ready</SPAN>

<TBODY>
</TBODY>

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

2013-03-22-15.15.52.219000</SPAN>
N8501
2013-03-22-15.15.31.936001N8601

<TBODY>
</TBODY>
 

Miguelluis

New Member
Joined
Jan 29, 2013
Messages
45
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,932
Messages
5,598,931
Members
414,268
Latest member
bluebandersnatch

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top