Connecting data between 2 spreadsheets

[Guest]

I am trying to create a spreadsheet where I enter a value (x) in a cell on
sheet 1. That value (x) then searches from sheet 2 (a range of values
already entered in). Once it matches the value (x) on sheet 2, I need it to
pull another cell value (y) on sheet 1 and enter it into a column on sheet 2
in the same row as value (x).

Is there a formula that I can create to do this? Any help would be greatly
appreciated.

Thank you.

 

[Guest]

One versatile way is to use INDEX/MATCH ..

In Sheet2, assume the lookup col is col A (where all the x's reside)

In Sheet1,
assume lookup values (the various x's) are placed in A1 down
put in B1:
=INDEX(Sheet2!E:E,MATCH(A1,Sheet2!A:A,0))
copy B1 down to return corresp values from Sheet2's col E [that's the
indexed part: INDEX(Sheet2!E:E, ... ] -- the y's that you want returned.
modify to suit.

 

[Guest]

Oops, think I read it the other way round.
Just swap "Sheet1" to "Sheet2" in the earlier descript/formula.

---