Return a number based on text

[ts656577]

All, I have a list of prices (quotes for work) and want to automatically add that price to a budget sheet if a cell adjacent has text. The cell with text would depend on whatever the user chose to select as the quote. The attachment has two options to show what i'd like to be able to happen. Picture as well. I've searched the internet but may not be searching for the right thing. All help is appreciated!

Capture.PNG

[AliGW]

Are you still using Excel 2007?

[AliGW]

This should work:

=INDEX($A$2:$A$6,MATCH("*",$B$2:$B$6,0))

[ts656577]

Are you still using Excel 2007?

I am not. Sorry, I updated my profile to 2016

[AliGW]

Thanks. Please see post #3.

[ts656577]

This should work:

=INDEX($A$2:$A$6,MATCH("*",$B$2:$B$6,0))

That was incredibly simple. I had tried vlookup but that is much easier to understand, thanks!

Is * a generic text character when searching for something

[AliGW]

Yes - it's what we call a wildcard character.

Glad to have helped.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.