I would 1st like to say thank you for anyone who reads this as what I am
currently doing is taking way to long and I'm sure there is a better way of
speeding this up.

This is what I'm trying to do. I have a workbook that contains 2 worksheets
(lets say 1 of them is called sheet1 and the other is sheet2) and I'm looking
at sheet1 to see if the same exact invoice number is on sheet2. I would like
to know if there is a forumula that will automatically look for the same
invoice number in sheet2 and display a true/false answer in sheet1 to let me
know whether or not the same invoice number exists in both worksheets.

If it would be rather difficult you think for me to do it this way I'm open
to other idea's. Thank you again for your time.

- Matt