Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Nov 2003
    Location
    Nebraska
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    excel problem (2002)

    I had such great success with my last problem that you all solved I have come to you again. As you can see from the attachment I am scanning in numbers in the scanning form work sheet. The column next to it analyses the serial number column to see if it's blank then goes to the serial # work sheet and it's suppose to find the number and report what product it is from the column right beside the serial number. The problem is it does not work. If a number is not there it still reports a product. Any thoughts?

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: excel problem (2002)

    Try using VLOOKUP like this:

    <pre>=IF(B25="","",VLOOKUP('Scanning Form'!B25,'copy of serial #'!A:B,2,FALSE))
    </pre>

    Legare Coleman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •