Improve company productivity with a Business Account.Sign Up

x
?
Solved

Excel Cell Match

Posted on 2013-02-06
4
Medium Priority
?
284 Views
Last Modified: 2013-02-06
Hello Experts

Can someone please take a look the sample spreadsheet and show me how to add the 'record count' in column B in sitelist1.xls  to Column M in sitelist2.xls.

For example in sitelist1.xls you see BIRMINGHAM (10 COLMORE ROW) with record count:1. There is also a BIRMINGHAM (10 COLMORE ROW) insitelist2.xls but without the record count. I would appreciate if someone could show me how match BIRMINGHAM (10 COLMORE ROW) in sitelist1.xls with BIRMINGHAM (10 COLMORE ROW) in sitelist2.xls and add the record count - and do the same for all the other cells.

I hope that makes sense.

Cheers
sitelist1.xlsx
sitelist2.xlsx
0
Comment
Question by:cpatte7372
  • 2
  • 2
4 Comments
 
LVL 23

Accepted Solution

by:
NBVC earned 2000 total points
ID: 38859481
Do you mean in sitelist2.xlsx, cell M2, add formula:

=IFERROR(VLOOKUP(TRIM(B2),[sitelist1.xlsx]Sheet1!$A:$B,2,0),"")

copied down.
0
 

Author Comment

by:cpatte7372
ID: 38859984
NB, you're a star, that's what you are :-)

Cheers mate.
0
 

Author Closing Comment

by:cpatte7372
ID: 38859987
Deserves a thousand points
0
 
LVL 23

Expert Comment

by:NBVC
ID: 38860114
Thank you cpatte7372
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
This article presents several of my favorite code snippets.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

606 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question