Micayla Bergen wrote:
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
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.
|