IF VLOOKUP

M

Micayla Bergen

Can i have an IF function VLOKUP? i.e. =IF(VLOOKUP(A4,'share
detail'!A2:A150,1, FALSE),1,"") if the vlookup is corrent (value is found
within table) then i want a value returned in the cell rather than whatever
is in the corresponding column.
Thanks
 
B

Bob Phillips

=IF(ISNA(vlookup_formula),"",vlookup_formula)

is what I thinkthat you want, but didn't really understand what you want if
not found.
 
F

Franz

Can i have an IF function VLOKUP? i.e. =IF(VLOOKUP(A4,'share
detail'!A2:A150,1, FALSE),1,"") if the vlookup is corrent (value is
found within table) then i want a value returned in the cell rather
than whatever is in the corresponding column.
Thanks
Click to expand...

You can truy with this:

=IF(NOT(ISERROR((VLOOKUP(A4,'sharedetail'!A2:A150,1, FALSE))),1,"")


--
Hoping to be helpful...

Regards

Franz
 
A

Aladin Akyurek

Micayla said:
Can i have an IF function VLOKUP? i.e. =IF(VLOOKUP(A4,'share
detail'!A2:A150,1, FALSE),1,"") if the vlookup is corrent (value is found
within table) then i want a value returned in the cell rather than whatever
is in the corresponding column.
Thanks
Click to expand...

If 'share detail'!A2:A150 is in ascending order...

=IF(A4 >= 'share detail'!A2,(LOOKUP(A4,'share detail'!$A$2:$A$150)=A4)+0,0)

Otherwise:

=ISNUMBER(MATCH(A4,'share detail'!$A$2:$A$150,0))+0

A 1 as result means a hit, 0 a failure.
 
Top