Excel - VLOOKUP Question - Urgent

Hi,

I think this is a really simple problem, but under pressure (!) and
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 V8
to W8, ABC. But then if "2" goes into P1, the word stays as ABC, and
does not update.

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

Ta

Andrew


---
Message posted from http://www.ExcelForum.com/

What have you got in V8:W9?

"ajw150 " wrote:

Hi,

I think this is a really simple problem, but under pressure (!) and
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 V8
to W8, ABC. But then if "2" goes into P1, the word stays as ABC, and
does not update.

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

Ta

Andrew


---
Message posted from http://www.ExcelForum.com/

Hi!

Are the numbers 1 and 2 exact or calculated? Could be an issue of
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.

Alf


---
Message posted from http://www.ExcelForum.com/

V W
8 1 Yes
9 2 No

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

Andrew


---
Message posted from http://www.ExcelForum.com/

What if you just type 2 into P1, does it work then?

"ajw150 " wrote:

V W
8 1 Yes
9 2 No

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

Andrew


---
Message posted from http://www.ExcelForum.com/

No, it just doesnt seem to refresh.


---
Message posted from http://www.ExcelForum.com/

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 formula
resides. It does seem, sometimes, that a bit of a worksheet becomes
unusable. It once took me nearly a month to realise that (before I knew
NGs existed...)

Alf


---
Message posted from http://www.ExcelForum.com/