using vlookup to find data in two spreadsheets

[jefferysteele]

Have spreadsheet #1 with data

Have spreadsheet #2 with new data added to the old data from spreadsheet #1

Old data from spreadsheet #1 may or may not have been updated/changed

Need to use vlookup to pull out the data in spreadsheet #2 that has been updated/changed

 

[Alpacino]

Where u want to put new data into the cell
Press =VLOOKUP(lookup value, then click on the sheet where the original table array is and highlight the area. Excel will automatically locate the array e.g 'Sheet1!' then, the column number you want , then 0)

Welcome to the board btw

 

[jefferysteele]

what would the lookup value be? I'm very limited in my knowledge of vlookups...

 

[Alpacino]

Hi,
The lookup value is the item u want to match the value you want look up e.g

Column1. Column2. Column3.
A. 1. [..........]
B. 2
C. 3
D. 4
E. 5

The lookup value is the cell in column 1 so if you want to find the number value for C in column 3 cell it would be cell that holds "C" The lookup value.
The formula would be =vlookup("c",A1:B6,2,0)