Newbie question! Pasting records associated with SOME dates between worksheets

[alexemberey]

Hi guys - hope everyone's well! Newbie here...

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

 

[RonB1111]

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.

 

[alexemberey]

Thanks so much Ron!

That's really helpful, problem solved.

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

Thanks again! Alex

 

[RonB1111]

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)