matching cell values

  • Thread starter Thread starter Geofridu
  • Start date Start date
G

Geofridu

I have a spreadsheet with cities and time zones. I have another with zip
codes, cities, states, and area codes. I would like to match up the time
zones with the cities in the second spreadsheet. I think the dlookup
function will do this, but I am not sure how to go about doing it - even
using the cities columns as a basis to match up on.

Any one out there who can help?

Thank you for your help and advice.

G
 
Hi

On sheet2 with the Area codes etc, in cell E2 enter
=VLOOKUP(B2,Sheet1!A:B,2,0)
and copy down as far as required.
 
Roger, thanks for the help.

Had issues with the cities having the same name but in different states and
the formula didn't copy down. I had to fix that with the "hard cell
reference" $A$1 versus A1 but was able to get done what I needed.

Thank you again for the help! It got me going in the right direction!
 

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

Need VLOOKUP to Work Two Ways 0
Vlookup with multiple fields that need to match 1
How do I pull certain data out of spreadsheet and import into another? 5
Lookup Exact Match 8
Two Critera to match another spreadsheet and return single criteri 2
VBAscript for data matching excels 0
Multiple Lookups - SIngle Result 8
sorting noncontiguous data with exceptions 3

Back
Top