returning a value according to characters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

if the active cell has the first 7 characters = "example", I want it to return a value in another cell. ie,

"example 7", "example fourty nine" and "example spiderman"

would all return a value, where as...

"7", "fourty nine" and "spiderman"

would not.

TIA
Chris
 
Maybe,

=VLOOKUP(LEFT(A1,7),MYLOOKUPTABLE,2,FALSE)

or.........

=IF(LEFT(A1,7)="example",B1,"")

Vaya con Dios,
Chuck, CABGx3


Chris said:
if the active cell has the first 7 characters = "example", I want it to
Click to expand...
return a value in another cell. ie,
 
Back
Top