vlookup text & values

  1. Jyggalag

    Get formula that pulls a number from a sentence in a cell

    Hi all! I have this setup (albeit much larger in reality): Every statement has a sentence with "XYZ employees". Is there a formula that can detect when a sentence says a number, followed by the string value "employees", and then return the value of the number? So that formula can fill out...
    • Jyggalag
    • Thread
    • christian røssel excel ezzzzzzzzzzzz formula help if formula iferror index indexmatch jonas sværke jonassvaerke match olzenmedz sanoj ekrævs sonaj jværke text vlookup vlookup text & values
    • Replies: 5
    • Forum: Excel Questions
  2. H

    VLOOKUP - return value from alternate sheet on match and specific text when no match

    Hello Everyone! I've searched and tried a number of variations of functions but am not getting a consistent result. I'm hoping that there is some excel magic out there and I'm thinking that it's not too difficult but I can't seem to resolve. The below function searches for the value in A2 in...
  3. J

    VLOOKUP not working - trying to return a number depending on a text character

    Hi, I have a spreadsheet that stores a persons grade as either say 5-, 5 or 5+. This column is stored as text. I have created a range of cells that has the text version of the score (i.e 6+ and I want to return the number 6, or if it's 5+, 5- I would return number 5). At present my vlookup...
  4. D

    Vlookup & Trim functions for a cell with text & number

    Hi all, Need a bit of help please. I'm have raw data which is dumped into Column C, which contains text and numbers, but is in text format i.e. 52345 Fixed Assets xxxx etc. I have used the following formula to pull the numbers I want into Column A...

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