Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VlookUp Help Please!
I am trying to pull addresses from a master address worksheet into columns on
another worksheet. The A2 column is sorted alpha, as is the first "matching column" on the Full Addresses worksheet. I want to pull column 3, and I want exact matches. I am pretty sure the formula is correct, but the worksheet only shows the formula, not my result. I do not have the ctrl +` on, it just will not show what I want it to pull, or even #N/A for a false result. What am I missing? Thanks! =vlookup(A2,'Full Address List(4-20-09)'!A1:J187,3,FALSE) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
VlookUp Help Please!
Make sure the cell the formula is placed in is NOT formatted as Text. Change
the format to "General" and then re-commit the formula (press F2 then Enter). HTH Elkar "tutink777" wrote: I am trying to pull addresses from a master address worksheet into columns on another worksheet. The A2 column is sorted alpha, as is the first "matching column" on the Full Addresses worksheet. I want to pull column 3, and I want exact matches. I am pretty sure the formula is correct, but the worksheet only shows the formula, not my result. I do not have the ctrl +` on, it just will not show what I want it to pull, or even #N/A for a false result. What am I missing? Thanks! =vlookup(A2,'Full Address List(4-20-09)'!A1:J187,3,FALSE) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
VlookUp Help Please!
Sounds like your formula column is formatted as text.
-- Regards Rob "tutink777" wrote in message ... I am trying to pull addresses from a master address worksheet into columns on another worksheet. The A2 column is sorted alpha, as is the first "matching column" on the Full Addresses worksheet. I want to pull column 3, and I want exact matches. I am pretty sure the formula is correct, but the worksheet only shows the formula, not my result. I do not have the ctrl +` on, it just will not show what I want it to pull, or even #N/A for a false result. What am I missing? Thanks! =vlookup(A2,'Full Address List(4-20-09)'!A1:J187,3,FALSE) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
VlookUp Help Please!
Thank you. It wasn't formatted as text, but a Social security number, and
that was the problem. Thanks. I am usually good at excel, but that had me in fits. Thank you both very much. "RobWN" wrote: Sounds like your formula column is formatted as text. -- Regards Rob "tutink777" wrote in message ... I am trying to pull addresses from a master address worksheet into columns on another worksheet. The A2 column is sorted alpha, as is the first "matching column" on the Full Addresses worksheet. I want to pull column 3, and I want exact matches. I am pretty sure the formula is correct, but the worksheet only shows the formula, not my result. I do not have the ctrl +` on, it just will not show what I want it to pull, or even #N/A for a false result. What am I missing? Thanks! =vlookup(A2,'Full Address List(4-20-09)'!A1:J187,3,FALSE) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |