Finding the top 4 highest keywords and number in an array

I've got a list of keywords and numbers. I want to find the cells that contain a specific word with the 4 highest numbers. I then want both the number and the word cell. I went for this:

=LARGE((VLOOKUP("*potato*",keyword_ideas_20130318_0820908.csv!$A$2:$C$827,3,0)),2)


To do it manually, I would filter the data containing to the word, then put it in numerical order then take the top 4. Is there a way to do it with a formula? I can't seem to get it working with combinations of LARGE and VLOOKUP.

Can you help at all? :-)

Hi Patrick
Welcome to the board

It's difficult to help you if we do not know the structure of the string.
Can you share it with us (and post some examples)?

For ex.:

Is the number at the end, like potato123? at the beginning like 123potato?
Is there a space between the word and the number?
Are there other words, like "best 1234 potato chips"?
Etc.

Thanks for getting back to me lecxe! And thanks for the warm welocome to the community. I've been using the site for a few weeks and it's absolutely brilliant.

The raw data looks like this:

[glazed carrots] 0.01 1600
[prawn cocktail] 0.01 4400
[potato dauphinoise] 0 6600
[no-bake chocolate tart] 0 58
[leek & potato soup] 0.11 590

I'd like to out put this

potato dauphinoise 6600 leak & potato soup 590

I thought I'd have a different formula per cell. Like LARGE=(array, 1) then LARGE=(array, 2). I tried replacing the "array" with a VLOOKUP and a COUNTIF and vice versa but it didn't get what I wanted. I was just guessing then though. I stopped short of an IF statement as I'm not up to pace with those formulas yet.
Thanks again,
Patrick