Search Function
Hi,
Let' say you have the 453 models in sheet 1 starting cell A2, the 8000
models are in sheet 2 column A and what is on hand in column B
so in cell B2 sheet 1 enter
=sumproduct(--(sheet2!$A$2:$A$9000=A2),sheet2!$B$2:$B$9000)
if you are using excel 2007 enter
=sumproduct(--(sheet2!A:A=A2),sheet2!B:B)
"cra88" wrote:
It has been a while since I worked with Excel and I have gone blank. Can
someone help me out please. I have 2 tabs, one with a list 453 model numbers
and the second with the entire 8000 models with the quantity on hand. I want
to create a list with the 453 models an the first tab and the quantity on
hand from the second tab.
Thanks
|