this one works
=MATCH(A3;$'Stock count 070712_2'.$A$3:$A$447;0)
But when i try
=INDEX('Stock count 070712_2'.$C$3:$C$447,MATCH(A3;$'Stock count 070712_2'.$A$3:$A$447;0))
this comes up with a err:508
Unable to upload due to company restrictions.
But i dont see anywhere that you comparing the stock code between worksheet A and Worksheet B or is that what the match is for?
thanks Hui
Yes both sheets have a header row and i hav adjusted the range of data but this doesnt seem to be working.
Range in Worksheet A is 1533 and in worksheet B it is 446
Hi
Please can you help me to create a new formula for the following
I have 2 worksheets that both contain stock codes in Column A
Worksheet A has a few thousand stock codes in column A
Worksheet B is a Stock on hand worksheet and only has the stock codes that have current stock on hand...