Vlookup

C

CH Coffieid

I am using a vlookup to find a specific value in a 2 column array.
=VLOOKUP(E32,[B4]Resources!$A$2:$B$38,2,1). The problem is it return
the correct value sometimes and incorrect values at other times. An
suggestions
 
C

Claus Busch

Hi,

Am Mon, 5 Nov 2012 19:26:26 +0000 schrieb CH Coffieid:
I am using a vlookup to find a specific value in a 2 column array.
=VLOOKUP(E32,[B4]Resources!$A$2:$B$38,2,1). The problem is it returns
the correct value sometimes and incorrect values at other times. Any
suggestions?

if you use false into the formula the columns must be sorted ascending


Regards
Claus Busch
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top