excel problem (2002)

Topic

New Reply

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?

Reply | Quote

Replies

Try using VLOOKUP like this:

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

Reply | Quote

Try using VLOOKUP like this:

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

Reply | Quote