Hi Barb,
As long as the table in sheet B has the SKU number before
the value to be returned you can use VLOOKUP. Worksheet Function
http://www.mvps.org/dmcritchie/excel/vlookup.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Barb" wrote in message ...
I have a spreadsheet with two worksheets (A and B).
(A) has information regarding stock ordered and in transit, and (B) is a
complete list, updated weekly, of stock on hand. Both worksheets contain a
column of identifying SKU numbers

I would like to create some kind of formula that will:
Look at the first cell of the column containing the SKU number in (A) and
search the SKU number column for a match in (B)
If/when it finds the identical SKU number in (B), it would find the current
stock on hand qty from that row
Then it would return that value (stock on hand) into an empty cell in
worksheet (A)

Then I could copy and paste this formula down through the whole spreadsheet
- Thanks to anyone who can help!