Search function

R

rajcobra

New Member
Joined
Nov 8, 2012
Messages
14
Dear Friends,

We have a cell with a text and need help on the below:
  • Cell has full text and If it has a word "expense" exists in the cell then perform vlookup with other sheet.
  • Else leave it blank.
Kindly help.
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
Sort by date Sort by votes
Try something like
Excel Formula: 
=IF(ISNUMBER(SEARCH("expense",A1)),VLOOKUP(lookup value, range containing the lookup value, the column number in the range containing the return value, Approximate match (TRUE) or Exact match (FALSE));"")
 
Upvote 0
Solution
Misca said:
Try something like
Excel Formula: 
=IF(ISNUMBER(SEARCH("expense",A1)),VLOOKUP(lookup value, range containing the lookup value, the column number in the range containing the return value, Approximate match (TRUE) or Exact match (FALSE));"")
Click to expand...
Thank you very much, it worked...
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Solved
Find Text in a cell
Replies
5
Views
155
Fluff
Fluff
L
  • Question
Step 2: VBA Macro to Sum
Replies
7
Views
256
offthelip
O
D
  • Question
Find text in one cell and add data to the cell below it
Replies
7
Views
331
rlv01
R
S
  • Question
Splitting text into only two cells ?
Replies
4
Views
151
Peter_SSs
Peter_SSs
R
  • Question
Best approach (VBA) to search through a sheet for all matches to a selected range (ie. multiple cells)?
Replies
2
Views
115
radiocam
R

Forum statistics

Threads
1,215,361
Messages
6,124,500
Members
449,166
Latest member
hokjock

Share this page

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
Back
Top