Formula Help Please

[Steved]

Hello from Steved

=IF(ISNA(VLOOKUP(C3,$A$3:$L$2000,12,0)),"",VLOOKUP
(C3,$A$3:$L$2000,12,0))

The above formula leaves the cell blank.

In Cell C3 I have the value ORPINGTON
In Column K:K I have Orpington
In Column L:L I have St Covet
The above formula is in cell F4
Why will it not return the Value in F4 "St Covet"

Thankyou.

 

[JE McGimpsey]

It won't find "Orpington" because it exists in column K and you're
telling VLOOKUP to look in column A.

Try:

=IF(ISNA(MATCH(C3,$K$3:$K$2000,0)),"",VLOOKUP(C3,$K$3:$L$2000,2,0))

 

[Niek Otten]

Change $A$3:$L$2000 to $K$3:$L$2000

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Steved]

Thankyou JE

-----Original Message-----
It won't find "Orpington" because it exists in column K and you're
telling VLOOKUP to look in column A.

Try:

=IF(ISNA(MATCH(C3,$K$3:$K$2000,0)),"",VLOOKUP (C3,$K$3:$L$2000,2,0))



.

 

[Don Guillett]

you are trying to look up c3 in col a and it is in col k
try
=IF(ISNA(VLOOKUP(C3,$K$3:$L$2000,2,0)),"",VLOOKUP(C3,$K$3:$L$2000,2,0))