PDA

View Full Version : Sleeper: Need formula help



austenr
08-18-2005, 01:18 PM
I need a formula that will compare two columns (A & D) to (F & I). I need it to look for the value in column A anywhere in a range from F1 to F300. If it is equal then check columns D against I and if it is not equal highlight the corresponding cell in column I. The ideal situation is where it would cross check and highlight anything that either does not match or is not present at all. I know conditional format is what to use just cannot come up with the formula. See attached sample spreadsheet.

Bob Phillips
08-18-2005, 01:38 PM
=OR(ISNA(MATCH(A1,$F:$F,0)),D1<>I1)

austenr
08-18-2005, 01:46 PM
hmmm...Can't seem to get it to work correctly. Could you apply it to the sample spreadsheet? Thanks

Bob Phillips
08-18-2005, 02:24 PM
.

austenr
08-18-2005, 02:40 PM
See the revised spreadsheet. Maybe that will make it a little more clear as to what I am looking for.

Bob Phillips
08-20-2005, 02:20 AM
See the "Bob's Version of Book1.xls" in the attached file.

austenr
08-20-2005, 10:03 AM
Is it possible to use VLOOKUP and highlight everything that does not match? In onther words, cross check?

Bob Phillips
08-20-2005, 10:43 AM
Is it possible to use VLOOKUP and highlight everything that does not match? In onther words, cross check?

VLOOKUP doesn't highlight, it returns a value? What do you want, a list of all of the numbers that don't match, or the dates?

austenr
08-21-2005, 01:54 PM
I would like to use conditional formatting in this situation

Bob Phillips
08-22-2005, 12:37 AM
I would like to use conditional formatting in this situation

I am obviously missing something here because the solution that I gave you does use conditional formatting. It uses MATCH rather than VLOOKUP, but they work similalrly if just checking whether an item is in a list.