I have three different worksheets and I am trying to use IF and LOOkUP
formulas to search two of the three worksheets for a specific result... I was
just using the LOOKUP function when I had just one worksheet to look at, but
now I want it to search two worksheets and thought using the if with the
lookup but... but the logical test is returning a "false" result even though
it found the correct result.