Capture information from one sheet

[shane24]

I have two spreadsheets. Spreadsheet 1 has a list of customers and some other information along with a notes column. Spreadsheet 2 has the same list of customers, with a additional customers included, and the other information on the spreadsheet has updates but does not have the notes. I want to move the notes from spreadsheet 1 to spreadsheet 2, understanding that some will be blank.

I've done it before with an HLookup, but can't find the example and someone had helped me through it. Help!?

[NBVC]

Hlookup would be used if you have customers listed in a row along the top of your sheet and corresponding info below each customer....is that the way you have the data set up....

Probably you have the customers listed vertically on the left and corresponding data to the right? Yes?

If so....you would use Vlookup.

e.g. =Vlookup(A2,Sheet2!A:Z,4,False)

where A2 is the first customer on your second sheet and Sheet2!A:Z is the table of customer and data on the first sheet... the 4 means you want to extract data from the 4th column within the A:Z range. The False means you want an exact match....

you will need to adjust these conditions and ranges to suit.

Then copy down the formula.

[shane24]

That helped straighten out my brain. Thank you very much!!