Solved

Excel Cell Match

Posted on 2013-02-06
4
256 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 500 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Convert SuperCalc files to Excel 9 45
Batch Numbering 6 30
Date Formatting on Userform Print 5 26
Conditional formatting excel 5 14
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

839 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