Scanning function?

seeker2003

New Member
Joined
Jan 21, 2005
Messages
1
Is there an excel function to scan a cell for a particular value?

e.g. Cell contains string "abcd", function will display "1" if "d" is in that string.

I know vlookup works, but you can only search on the 1st column and would like the flexibility to search other columns.

TIA.
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Joe Was

MrExcel MVP
Joined
Feb 19, 2002
Messages
7,539
No, you will need to use the "Find" function or test individual characters with the "Mid, Right and/or Left" functions!
 

Tazguy37

MrExcel MVP
Joined
May 28, 2004
Messages
4,237
You could search whatever cell you want with something like this:
=IF(ISERROR(FIND("d",E25)),"text for error",1)

Just change your search range, seach text, and error text to suit your needs. Hope that helps!
 

Watch MrExcel Video

Forum statistics

Threads
1,129,751
Messages
5,638,151
Members
417,010
Latest member
jnuss03

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top