|
|
|
|
"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)
----------------------------------------------------------------------------------------
|