Here is my problem, I have one sheet that has info that is being listed on
another seperate sheet. I can get the info to populate the cell, but it will
put the last set of numbers in a cell if the listing is not there. Here is
the formula I am using:
=LOOKUP(A2,'Lot Check'!$B$2:$B$167,'Lot Check'!$A$2:$A$167)
I have tried vlookup and they do not seem to work. Any help would be great.

Thanks
P.T. in Phx