Good morning,
In the attached file, I am trying to determine the system each of the values in column A are involved in and I can't get a nested IF function to work. Below is the criteria for the formula:
If the value in column A does not exist in columns I or L, I want the system to be displayed as "GF".
If the value in column A is featured in column I and column L, I want the system to be displayed as "GF/MIB/RM".
If the value in column A is featured in column I but not featured in column L, I want the system to be displayed as "GF/MIB".
If the value in column A is featured in column L but not featured in column I, I want the system to be displayed as "GF/RM".
This is what I tried but am getting a "#N/A" for results that should be "GF/MIB".
=IF(AND(VLOOKUP(A2,I:I,1,FALSE)=A2,VLOOKUP(A2,L:L,1,FALSE)=A2),"GF/MIB/RM",IF(AND(VLOOKUP(A2,I:I,1,FALSE)=A2,VLOOKUP(A2,L:L,1,FALSE)<>A2),"GF/MIB","GF"))
What am I doing wrong?
Bookmarks