Excel - VLOOKUP Question - Urgent

A

ajw150

Hi,

I think this is a really simple problem, but under pressure (!) an
need to solve the problem. Please can you help.

I am using this formula:

=VLOOKUP($P$1,V8:W9,2,FALSE)

to match a number to corresponding word.

The problem is that, if "1" is in P1, then it matches the word from V
to W8, ABC. But then if "2" goes into P1, the word stays as ABC, an
does not update.

Do you get what I mean? Please can you help as to why its doing this.

Ta

Andre
 
A

AlfD

Hi!

Are the numbers 1 and 2 exact or calculated? Could be an issue o
rounding.

However, you could alternatively put in your cell

=if($P$1=1,"ABC",""XYZ")

or (in case there are more values than 1 & 2 to go in P1)

=if($P$1=1,"ABC",if($P$1=2,"XYZ",""),"")

or

=if($P$1=1,W8,W9)

or some combination of these.

Al
 
A

ajw150

V W
8 1 Yes
9 2 No

The value in P1, is coming from a dropdown box. Initially I was usin
data validation list but couldnt gfet that to work.

Andre
 
A

AlfD

Hi!

2 things:

a) Have you tried the "if" approach I suggested? If so, what happened?

b) One strategy might be to remake the column in which your formul
resides. It does seem, sometimes, that a bit of a worksheet become
unusable. It once took me nearly a month to realise that (before I kne
NGs existed...)

Al
 
Top