How do I match values in one spreadsheet to values in another?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to match some numbers from a column in one spreadsheet to the
numbers from another spreadsheet. I basically want to match up which numbers
are in both lists. I also want to bring the information from other columns
with that number.
 
vlookup is your friend


=VLOOKUP(A1,'Sheet 1'!A:B,2,FALSE)

where by A1 is the value you need to look up

Sheet 1 is where you're looking into. Column 1 is always the "looked
up" range and the 2 is the column number of where the information you
wish to pull back is held.

Make sure you enter false at the end so that you don't have to worry
about the list being sorted.


If it comes back as #n/a then the value doesn't exist in the reference
range.
 
You must log in or register to reply here.

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

Match two values 2
With F1 value, look at A, if match or partial match return B 5
Lookup returning wrong results 0
Using MATCH 7
Convert Number to Text for Index/Match 1
Find matching values 2
Match Text return a value from the row 2
Lookup/Match Formula 1

Back
Top