# Comp. value in 2 columns against a list and disp. text in 3r

Rschewe1

TrowaD

- Posts
- 1
- Registration date
- Tuesday March 15, 2022
- Status
- Member
- Last seen
- March 15, 2022

TrowaD

- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022

## 1 reply

TrowaD

Updated on Apr 25, 2022 at 12:00 PM

- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022

Updated on Apr 25, 2022 at 12:00 PM

Hi Rschewe1,

You can give the following formula a try:

This is the formula for row 2, where the List is located in Column A (rows 2:7), Value A in Column B and Value B in column C.

Best regards,

Trowa

You can give the following formula a try:

**=IF(IF(B2=C2,"local","")<>"",IF(B2=C2,"local",""),IF(IF(AND(ISERROR(VLOOKUP(B2,$A$2:$A$7,1,0)),B2<>""),"",IF(AND(ISERROR(VLOOKUP(C2,$A$2:$A$7,1,0)),C2<>""),"remote",""))<>"",IF(AND(ISERROR(VLOOKUP(B2,$A$2:$A$7,1,0)),B2<>""),"",IF(AND(ISERROR(VLOOKUP(C2,$A$2:$A$7,1,0)),C2<>""),"remote","")),IF(IF(AND(ISERROR(VLOOKUP(C2,$A$2:$A$7,1,0)),C2<>""),"",IF(AND(ISERROR(VLOOKUP(B2,$A$2:$A$7,1,0)),B2<>""),"assigned",""))<>"",IF(AND(ISERROR(VLOOKUP(C2,$A$2:$A$7,1,0)),C2<>""),"",IF(AND(ISERROR(VLOOKUP(B2,$A$2:$A$7,1,0)),B2<>""),"assigned","")),IF(IF(AND(B2="",IF(ISERROR(VLOOKUP(C2,$A$2:$A$7,1,0)),"")<>""),"available","")<>"",IF(AND(B2="",IF(ISERROR(VLOOKUP(C2,$A$2:$A$7,1,0)),"")<>""),"available",""),IF(IF(AND(C2="",IF(ISERROR(VLOOKUP(B2,$A$2:$A$7,1,0)),"")<>""),"vacant","")<>"",IF(AND(C2="",IF(ISERROR(VLOOKUP(B2,$A$2:$A$7,1,0)),"")<>""),"vacant",""),IF(IF(AND(B2<>C2,IF(ISERROR(VLOOKUP(B2,$A$2:$A$7,1,0)),"")<>"",IF(ISERROR(VLOOKUP(C2,$A$2:$A$7,1,0)),"")<>""),"crossed","")<>"",IF(AND(B2<>C2,IF(ISERROR(VLOOKUP(B2,$A$2:$A$7,1,0)),"")<>"",IF(ISERROR(VLOOKUP(C2,$A$2:$A$7,1,0)),"")<>""),"crossed",""),"Criteria not met"))))))**This is the formula for row 2, where the List is located in Column A (rows 2:7), Value A in Column B and Value B in column C.

Best regards,

Trowa