VLOOKUP

  • Thread starter Thread starter asg2307
  • Start date Start date
A

asg2307

I need to better understand VLOOKUP. I need to map two tables which have
matching zip codes but one does not has less due to less data. Is there a
way to do what the link below does? Basically I am a sumproduct guy happy to
get the total data that comes from what I ask. Now I need text information
from the shorter table that matches numerical data from the larger table.

http://www.ablebits.com/excel-lookup-tables/index.php
 
Hi,

=VLOOKUP(Key,Table,Column,Type)

Key is the value you want to look up in the first column of Table

Table is a range whose first column contains the values which Key is looking
for, and the other columns are the columns you might want to return.

Column specifices the column number of the column within the table which you
want to return. The first column of a table is always 1.

Type determines whether you are doing and exact match or approximate. In
your case Exact sound more appropriate - FALSE or 0 work for that.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Back
Top