Is it possible to look at 2 different columns and if both are true THEN return a vlookup value?
What I "need" is IF the closed Resolved value is "No" AND VIP is TRUE then vlookup to show the description...
Now that I am typing this, I see a problem.
In the example there would be 2 it would return. Is there any way to display both (IN 2 cells)? I don't think there would be....
Any help would be appreciated if you have read this far.
If I have data like below:
What I "need" is IF the closed Resolved value is "No" AND VIP is TRUE then vlookup to show the description...
Now that I am typing this, I see a problem.
In the example there would be 2 it would return. Is there any way to display both (IN 2 cells)? I don't think there would be....
Any help would be appreciated if you have read this far.
If I have data like below:
Open | Resolved | VIP | Description |
10-Jan | Yes | TRUE | Desc 1 |
11-Jan | Yes | TRUE | Desc 2 |
12-Jan | No | TRUE | Desc 3 |
11-Jan | No | FALSE | Desc 4 |
12-Jan | No | TRUE | Desc 5 |