VLookup....

[burningisolatio]

I am trying to match an item# from 1 column on spreadsheet 1...find it on spreadsheet 2 and have the column b data from spreadsheet 2 filter into spreadsheet 1.
-spreadsheet 1 has column A ZP101
-spreadsheet 2 has column A ZP101 and column B AC3250
I need the column B info to come to spreadsheet 1

Any help would be greatly appreciated..

[Special-K]

Assuming value is in A1, should be something like

=VLOOKUP(A1,Sheet2!A1:B5,2,FALSE)