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.