Problem statement:
Suppose I have a excel sheet with a column {column A} with some set of data. Another {Column B}with some set of data. Now I need to confirm whether the data in first column/cell exists anywhere in the second column. If it exists then indicate it by the data of the first column/cell or a Yes or No confirmation in an adjacent cell.
Solution:
I have tried the following combination in excel 2003 {ex. in column C}
=IF(ISNA(VLOOKUP(A2,$B$2:$B$600,1,FALSE)),"N",A2)
Why can't I use vlookup to achieve this? - Ans: I do not know :-) I have tried it but could not make it work.
Suppose I have a excel sheet with a column {column A} with some set of data. Another {Column B}with some set of data. Now I need to confirm whether the data in first column/cell exists anywhere in the second column. If it exists then indicate it by the data of the first column/cell or a Yes or No confirmation in an adjacent cell.
Solution:
I have tried the following combination in excel 2003 {ex. in column C}
=IF(ISNA(VLOOKUP(A2,$B$2:$B$600,1,FALSE)),"N",A2)
Why can't I use vlookup to achieve this? - Ans: I do not know :-) I have tried it but could not make it work.
No comments:
Post a Comment