Excel 2007 : Getting data from another spreadsheet

[pablo1]

Hello there

I have to update a big database, I could get the data from the web and input it manually, but just wonder if there is easier way, as otherwise it will take me ages.

Im able to get the data from another spreadsheet, but dont know how to implement it.
My original database includes names like: ABCDE, XYZRR, GHGJE, and another spreadsheet got the values referencing to the names which I need, but the names in other spreadsheet are not in the same order as in my databse. So the way I was thinking to do it was to include the formula like: if (column a:a: in other spreadsheet contains the name from "a1", then input value 3 columns to the left from ABC. So if the name im looking for found in the cell A25, i want the value of the cell in D25 in my original spreadsheet.
Is it possible to do it with function?
I hope I explained it clearly. If you need some more clarification let me know.

Best Regards
Pablo

[NBVC]

I think you are looking at VLOOKUP()

eg

=IFERROR(VLOOKUP(A1,'Sheet2'!$A:$D,4,FALSE),"")

copied down

where Sheet2, column A contains data to match and column D (4 columns over) has data to return in case of match....

The IFERROR() will allow return of a blank if no match is found instead of an error code.

[pablo1]

Thanks a lot. It works perfect!!
Cheers
Pablo