returning a value according to characters

C

Chris

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
 
C

CLR

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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

character limitations 1
searching for the first few characters in an active cell 1
Newbie Help - IF Yes No Function 0
Integrating information from Word to Excel (not mail merge) 1
Help with column accumulation needed 2
Page numbering with Merged Document and IF statements 1
Calculate the median value before a specified list 0
Locate row based on two criteria 0

Top