Adding condition to vlookup!!

[omairhe]

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

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.

 

[Tetra201]

Maybe this:

=IF(VLOOKUP(E1,A:C,3,0)=1,VLOOKUP(E1,A:B,2,0),"")

 

[thinhvd]

=If(C1=1,VLOOKUP(E1,A:B,2,0),0)

 

[Guru008]

Try this

=IF(VLOOKUP(E1,A1:c50,3,0)=1,VLOOKUP(E1,A1:C50,2,0),"")

 

[omairhe]

This does the trick..

TY.

Maybe this:

=IF(VLOOKUP(E1,A:C,3,0)=1,VLOOKUP(E1,A:B,2,0),"")

 

[Tetra201]

Glad to have been of help.