If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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/ |
#2
|
|||
|
|||
Excel - VLOOKUP Question - Urgent
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/ |
#3
|
|||
|
|||
Excel - VLOOKUP Question - Urgent
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/ |
#4
|
|||
|
|||
Excel - VLOOKUP Question - Urgent
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/ |
#5
|
|||
|
|||
Excel - VLOOKUP Question - Urgent
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/ |
#6
|
|||
|
|||
Excel - VLOOKUP Question - Urgent
|
#7
|
|||
|
|||
Excel - VLOOKUP Question - Urgent
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/ |
Thread Tools | |
Display Modes | |
|
|