Microsoft Office Forums - View Single Post - how to find one text i anather

Thread: how to find one text i anather

View Single Post

Old

08-17-2009, 11:33 PM

penghuipan penghuipan is offline

penghuipan is offline

penghuipan uses Windows 2K

Windows 2K penghuipan uses Office 2003

penghuipan uses Office 2003

Office 2003

Novice

Join Date: Aug 2009

Posts: 2

penghuipan is on a distinguished road

Default

Hi Kikus,
I think use this formula will be get the value you wanted:
if(vlookup($a1,$b$1:$b$10,1,0),"true","false").

Reply With Quote