VLOOKUP stopped working

Good afternoon. I have attached a worksheet we use regularly. The second tab is supposed to use a data validation to reference a Purchase Order number tab on the first tab (ODP Listing). From there it is then supposed to pull in the relevant information. Up until recently, this worked seamlessly. However, now we either get the wrong information pulling into column I on tab 2 (labeled Invoices) and/or the information pulls over as #N/A. Any help with what has gone askew would be greatly appreciated.

My old excel guru that I would normally ask is no longer with my company I have attached the instructions she left me but the formulas are WAY above my understanding!!

You should change the formula in D4 to this:

=IF(C4=0," ",VLOOKUP(C4,'ODP LISTING'!B:C,2,0))

and the one in I4 to this:

=IF(C4=0," ",VLOOKUP(C4,'ODP LISTING'!B:J,9,0))

then copy those down as far as you need to.

Hope this helps.

Pete

Thank you for your quick reply. I must still be doing something wrong. It is now pulling the information but not pulling it correctly. The PO number is not tying to the correct vendor with the lookup?

Seems to work okay for me- please give some examples of the problems you are having.

Pete