Hey all ,
Hope you all are well . I have data in 3 columns A, B and C
Currently I run formula for vlookup that looks like this = "=VLOOKUP(E1,A:B,2,0)"
The results are ok. but I now want to add a condition that if column C's value = 1 then show me the result of vlookup from the formula above and if value is not 1 then do nothing.
for instance
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
Cell E1 = 123
output = ""
Cell E1 = 124
output = ""
Cell E1 = 125
output = ghi
So when "1" was found in target.row of column C then the vlookup worked for that particular row and output the desired value.
Will appreciate a lot..
THANKS.
Hope you all are well . I have data in 3 columns A, B and C
Currently I run formula for vlookup that looks like this = "=VLOOKUP(E1,A:B,2,0)"
The results are ok. but I now want to add a condition that if column C's value = 1 then show me the result of vlookup from the formula above and if value is not 1 then do nothing.
for instance
Column A | Column B | Colulmn C |
123 | abc | 3 |
124 | def | 2 |
125 | ghi | 1 |
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
Cell E1 = 123
output = ""
Cell E1 = 124
output = ""
Cell E1 = 125
output = ghi
So when "1" was found in target.row of column C then the vlookup worked for that particular row and output the desired value.
Will appreciate a lot..
THANKS.