• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. R

    Creating a new formula

    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
  2. R

    Creating a new formula

    Hui I have tried the MATCH on its own and that works and gives me relevant positions but it comes up with a error when i try the whole formula
  3. R

    Creating a new formula

    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?
  4. R

    Creating a new formula

    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
  5. R

    Creating a new formula

    Should i be trying Vlookup or IF functions or is there something else i can use.
  6. R

    Creating a new formula

    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...
Back
Top