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
|
|||
|
|||
Vlookup question
I'm using VLOOKUP to pull a value from a range if the number in C33 finds a
match within that range. Here's the function: =VLOOKUP(C33,$C$249:$D$390,2,FALSE) This has always worked, and still occasionally works, but for some reason it's become unreliable. Here's what I'm trying to match it from and to: Date Name Number #1 Number #2 (function is in 5th column) Number Date Number #1 Number #2 So the function is searching for Number #1 found in row 1 and trying to find Number #1 in row 2. If it finds a match, then it pulls Number #2 from row 2 and puts it into the 5th column of row 1. Any ideas? Thanks in advance! |
#2
|
|||
|
|||
Vlookup question
Hi,
As stated, this is not what the VLOOKUP function is designed to do. This function =VLOOKUP(C33,$C$249:$D$390,2,FALSE) is designed to look for C33 in COLUMN C (C249:C390) and return the entry in COLUMN 2 of that range (column D). If you are trying to match a row and then get an item from another row you need HLOOKUP. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "*zot*" wrote: I'm using VLOOKUP to pull a value from a range if the number in C33 finds a match within that range. Here's the function: =VLOOKUP(C33,$C$249:$D$390,2,FALSE) This has always worked, and still occasionally works, but for some reason it's become unreliable. Here's what I'm trying to match it from and to: Date Name Number #1 Number #2 (function is in 5th column) Number Date Number #1 Number #2 So the function is searching for Number #1 found in row 1 and trying to find Number #1 in row 2. If it finds a match, then it pulls Number #2 from row 2 and puts it into the 5th column of row 1. Any ideas? Thanks in advance! |
#3
|
|||
|
|||
Vlookup question
I'm not sure what you're trying to do but here's how your lookup formula
works: =VLOOKUP(C33,$C$249:$D$390,2,FALSE) Let's assume C33 = x The formula is looking for "x" in the range C249:C390. If it finds "x" it returns the corresponding value from D249390. If it doesn't find "x" in C249:C390 then the formula returns the error #N/A. -- Biff Microsoft Excel MVP "*zot*" wrote in message ... I'm using VLOOKUP to pull a value from a range if the number in C33 finds a match within that range. Here's the function: =VLOOKUP(C33,$C$249:$D$390,2,FALSE) This has always worked, and still occasionally works, but for some reason it's become unreliable. Here's what I'm trying to match it from and to: Date Name Number #1 Number #2 (function is in 5th column) Number Date Number #1 Number #2 So the function is searching for Number #1 found in row 1 and trying to find Number #1 in row 2. If it finds a match, then it pulls Number #2 from row 2 and puts it into the 5th column of row 1. Any ideas? Thanks in advance! |
Thread Tools | |
Display Modes | |
|
|