Newbie question! Pasting records associated with SOME dates between worksheets

alexemberey

New Member
Joined
Apr 13, 2013
Messages
3
Hi guys - hope everyone's well! Newbie here... :) :eeek:

I have one worksheet where there are records (rows) with 4 fields (columns) for 8 days in a month, but none of the others.

I have another, pre-existing worksheet where there need to be records for ALL days, even if the values returned for each field are 0.

How can I paste the 8 records into the second worksheet as simply as possible, without manually matching each record to the correct date?

Thanks so much for any help you can provide!

Alex
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
Use VLOOKUP formula. Here's a link explaining it: Excel VLookup Function Examples

If you need help creating the formula, please post sample data showing names of sheets and columns and row where data starts/ends.

Your final formula in B2 of your pre-existing sheet will look something like:
=IFERROR(VLOOKUP(A2,Sheet1!$A$2:$A$1000,2,FALSE),0)
This assumes the 1st worksheet described is named Sheet1 and the dates are in A2 thru A1000 and the 3 other fields are in Cols B, C, & D
You'd change the 2 to 3 for C2, and to 4 for D2 then copy the formulas down to the end of data. Of course you'll need to adjust the names/ranges to suit your actual data.
 
Upvote 0
Thanks so much Ron!

That's really helpful, problem solved.

In the end I used IF(ISNA(VLOOKUP ....),0,VLOOKUP).

Thanks again! Alex
 
Upvote 0
You're welcome. Thank you for providing feedback.

If you're using Excel 2003 or earlier, you'd have to use the IF(ISNA(VLOOKUP ....),0,VLOOKUP). If you use Excel 2007+, you have the option of using the shorter IFERROR(VLOOLUP....),0)
 
Upvote 0

Forum statistics

Threads
1,222,143
Messages
6,164,175
Members
451,880
Latest member
2da

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
Back
Top