LOOKUP Formula Question/Help Needed

  • Thread starter Thread starter smarvaso
  • Start date Start date
S

smarvaso

I need to figure out how to take the information in one spreadsheet an
import it into another.

Here's what I have: Two spreadsheets, one titled OLD, one titled NEW.
Each spreadsheet has a column that shows the ID of a person (column H)
Every ID on NEW should have a matching ID on OLD. OLD has about 380
entries, and NEW only has about 1900, so only half should match.
What I need is to say "if the value of H41 in NEW matches a valu
anywhere in Column H on OLD, then the value of this cell is th
corresponding value in Column L of OLD". At least that's what I thin
I need.

Do I make any sense, and if so, can anyone help???

I've trie
=LOOKUP(H41,[OLD.xls]Sheet1!$H$3:$H$3895,[OLD.xls]Sheet1!$L$3:$L$3895)
and
=LOOKUP(H41,[OLD.xls]Sheet1!$H$3:$H$3895,[OLD.xls]Sheet1!$L$3:$L$3895
FALSE)

Both look like they work, but when I actually run it I get completel
mis-matched results..
 
Hi
try
=VLOOKUP(H1,'old'!$H$1:$L$4000,5,0)

--
Regards
Frank Kabel
Frankfurt, Germany

I need to figure out how to take the information in one spreadsheet
and import it into another.

Here's what I have: Two spreadsheets, one titled OLD, one titled NEW.
Each spreadsheet has a column that shows the ID of a person (column
H). Every ID on NEW should have a matching ID on OLD. OLD has about
3800 entries, and NEW only has about 1900, so only half should match.
What I need is to say "if the value of H41 in NEW matches a value
anywhere in Column H on OLD, then the value of this cell is the
corresponding value in Column L of OLD". At least that's what I think
I need.

Do I make any sense, and if so, can anyone help???

I've tried
=LOOKUP(H41,[OLD.xls]Sheet1!$H$3:$H$3895,[OLD.xls]Sheet1!$L$3:$L$3895)
and
Click to expand...
=LOOKUP(H41,[OLD.xls]Sheet1!$H$3:$H$3895,[OLD.xls]Sheet1!$L$3:$L$3895,
FALSE)

Both look like they work, but when I actually run it I get completely
mis-matched results...
Click to expand...
 
Back
Top