View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tutink777 tutink777 is offline
external usenet poster
 
Posts: 3
Default 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)