VLOOKUP syntax ?

  • Thread starter Thread starter Alien
  • Start date Start date
A

Alien

I have a cell with all of this in it.

7 Hi Ho Harley D 70 - Ferrell Best Time 38.27 Starts JA 16 0 3 4 2
Starts OP 54 8 14 10 8

it cannot be changed to any other format.

I am using the formula below, elsewhere for a vlookup

=IF(V5>0.9,IF(V5<9,"",VLOOKUP(V5,$AG$1:$AH$21,2)))

(The absolute references have been changed to reflect the correct
cells)

Instead of it looking for a number between 0.9 and 9, I would like it
to look for
"Ferrell" in cell V5 and return tha matching value that is in column
AH.
How do I make this simple change?
TIA, simpleton
 
use:
=IF(ISERR(IF(FIND("Ferrell",C9),C9,"")),"",IF(FIND
("Ferrell",C9),C9,""))

where C9 is the cell that contains the long string
 
Not exactly what I was looking for, MY fault not enough info!

I need a formula that will do a vlookup in cells $AG$1:$AH$21
It will be matching 1 of 21 names in cells AG1 through AG21 to a value
in cells AH1 through AH21.

It will be looking for a name in cell B8.

in cell B8 is one of these 3 or something similar
In this example it will be doing a vlookup on the name
1. Delisle

1 Calypso Spirit 58 - Patsy Delisle Best Time 31.6 Starts JA 15 1 3 3
2 Starts OP 18 0 3 8 2
In this example it will be doing a vlookup on the name
1. Delisle

2 Kay Kiowa Rock 55 - James E O'Donnell Best Time 31.51 Starts JA 16 2
2 2 0 Starts OP 20 2 1 2 4
In this example it will be doing a vlookup on the name
2. O'donnell,

3 Rapido Girlfrend 59 - Rapido Kennel Best Time 31.4 Starts JA 15 0 4
1 4 Starts OP 4 0 0 0 0
In this example it will be doing a vlookup on the name
3. Rapido


Thanks again!
 
Aside from other difficulties, I don't see anyway to provide a formula
that would identify Delisle, if Patsy Delisle were in Cell B38, and
Rapido (rather than Kennel) if Rapido Kennel were in Cell B38. The
organization of your data does not lend itself to retrieval.

Alan Beban
 
Back
Top