Compare multiple values

[C90RanMan]

I have included a sample attachment of what i am attempting to do. I found similar solutions on Google but i dont totally understand the syntax.
I am trying to compare two cells . . . if equal . . . compare two other cells.
If the first pair are not equal, then vlookup B1
If the 1st is equal but the 2nd isn't, vlookup B1
If both are equal then do nothing.

Has anyone ever encountered this issue?

Thanks!

Ran

[DonkeyOte]

The VLOOKUPs appear identical - in which case perhaps simply:

Please Login or Register  to view this content.

[scottylad2]

my stab is you need this

=IF(AND(C8=I8,E8=K8),"",IF(OR(C8=I8,E8<>K8),VLOOKUP($B$1,StyleDetail!$A$1:$BF$65536,33,FALSE),IF(C8<>I8,VLOOKUP($B$1,StyleDetail!$A$1:$BF$65536,33,FALSE))))

maybe the second and third if swapped around, untested though

[C90RanMan]

Thanks for the replay Don! you help is always a plus. However . . . perhaps i didnt explain my situation as well i i thought. LOL
I corrected my "TEST3" . . . hopefully i have a good explination.



Thanks so much!

[DonkeyOte]

I confess I don't see how the prior suggestion needs to alter - the formula suggested simply states if either result pair does not match perform the VLOOKUP outlined.
(other than the fact you intend to double evaluate the VLOOKUP re: blanks)

[C90RanMan]

Thanks Don. Last night i was working on this issue at home and this is what i came up with . . . . .
IF(G8&H8=VLOOKUP($C$1,StyleDetail!$A:$BF,31,FALSE)&VLOOKUP($C$1,StyleDetail!$A:$BF,32,FALSE),"",VLOOKUP($C$1,StyleDetail!$A:$BF,31,FALSE))

Do you forsee any problems with this solution. All it does is combine G8 & D8 for a unique number . . . the combines two vloookup's . . . . is the two dont match it the performs an additional vlookup.


Thanks again Don.
As usual, i saved you suggestions and formula for future reference.

C90RanMan

[DonkeyOte]

The above bears little resemblance to the layout of the sample file so I can't really pass comment at this stage.

All I was stating previously was that you need only compare the result pairs - if either failed to match perform the VLOOKUP else return Null.

At this point I don't really have much of an idea of what is going on I'm afraid...