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(ISNA(vlookup_formula),"",vlookup_formula)

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

--
HTH

Bob Phillips

"Micayla Bergen" wrote in message
...
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

"Micayla Bergen" ha scritto nel
messaggio

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

You can truy with this:

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


--
Hoping to be helpful...

Regards

Franz

----------------------------------------------------------------------------------------
To reply translate from italian InVento (no capital letters)
----------------------------------------------------------------------------------------

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.