richard hales
Board Regular
- Joined
- Feb 18, 2009
- Messages
- 55
- Office Version
- 365
- 2019
- Platform
- Windows
Hi Everyone
I have a formula which as work great for me for a while now =IF(LEN(A2&B2),IF(COUNT(A2,B2)=0,RIGHT(LOOKUP("zzz",A2:B2),2)+0,""),"") can someone please help me to tweak it a bit more.
Am looking for the formula to look for certain key words.
The formula is placed in C2 and looks into A2 for the certain key word bus and then returns the number back to C2 and the same for D2 key word car & E2 key word Bike.
Many thanks
Richard
I have a formula which as work great for me for a while now =IF(LEN(A2&B2),IF(COUNT(A2,B2)=0,RIGHT(LOOKUP("zzz",A2:B2),2)+0,""),"") can someone please help me to tweak it a bit more.
Am looking for the formula to look for certain key words.
The formula is placed in C2 and looks into A2 for the certain key word bus and then returns the number back to C2 and the same for D2 key word car & E2 key word Bike.
Many thanks
Richard