Search : in
By :

Index and matching 2 different spreadsheets

Last answer on Oct 28, 2009 5:14:26 pm GMT cookie, on May 4, 2009 3:26:49 pm BST 
 Report this message to moderators

Hello,

i am trying to index and match two diffrent excel spreadsheets. one has the same info on it as the other except for one column. i'm trying to add that data over on the other spreadhseet becaue not all the names are on the spreadsheet i'm trying to get a result on. please help. example: i'm trying to place the job location to the blank column using index and match, because not all names are on the first sheet.

first spreadsheet:
name address job title age location
john doe - 555 w sample rd - hr rep 35 blank
sally mae - 101 3rd st - assistance 25 blank


second spreadsheet
name address job title age job location
john doe - 555 w sample rd - hr rep 35 georgia
sally mae 101 3rd st assistance 25 florida

Configuration: Windows XP Internet Explorer 6.0

Best answers for « index and matching 2 different spreadsheets » in :
[VMWare] The different modes of VMWare network Show[VMWare] The different modes of VMWare network If you create a virtual machine using VMWare, 3 types of connectivity are provided: Host-only, NAT or Bridged. You can't use NAT and Bridged modes if you do not have the following...
Introduction to network bridge ShowIntroduction to network bridge What is a bridge? XP network bridge: between a wired network and a WiFi network What is a bridge? A bridge has a foot in each network and acts on the link layer (level 2). It is able to pass frames from...
[PHP] Notice: Undefined index Show[PHP] Notice: Undefined index When using $ _POST or $ _GET to retrieve the variables from a form , you may encounter this error: Notice: Undefined index 'fields of the table' in 'path of php file being executes' on line 'current...
Download Free Video 2 Screensaver ShowIf you are fed up with the screensavers that you have on your computer or those that you see on the internet, the best solution is to create your own screensavers. Free Video 2 Screensaver is a freeware which you will allow you to create...
Spreadsheet - Functions ShowThe Concept of a Function Spreadsheets generally have a large number of integrated functions for processing data. There are hundreds, categorised as follows: Arithmetic functions that offer basic tools to process numerical data Statistical...
Spreadsheet - Formulas ShowIntroduction to Formulas The main use of a spreadsheet is to automate calculations, which means using cells to perform operations based on values in other cells. The spreadsheet recalculates all the values each time a change is made to the value of...
Types of networks ShowDifferent types of networks Different types of (private) networks are distinguished based on their size (in terms of the number of machines), their data transfer speed, and their reach. Private networks are networks that belong to a single...
Ask your question Reply

1

mubashir aziz, on May 6, 2009 6:02:24 am BST

Now write below formula in Sheet1 column location which suppose in A2

You are writing this formula in blank cell of sheet1
=INDEX(Sheet2!D:D,MATCH(A2,Sheet1!C:C,0))
Sheet2!D = This is the column of location in sheet2
Match(A2 This is the Name which you are searching for from Sheet1 to Sheet2
Sheet1!C:C This is the column "Name" in Sheet1

Just try above formula and do let me know ...........






Never ashamed to get or give Advise.
Muhammad Mubashir Aziz , Lodhran

   
Reply to mubashir aziz

2

fee, on Oct 26, 2009 3:29:50 pm GMT
  • +1

Hi, i tried but the formula can't seem to work
example s/s 1 have column a-d which is similar to s/s 2, and i'm trying to index column e in s/s 1 over to s/s 2.
how do i do that?

   
Reply to fee

3

 valid numbers, on Oct 28, 2009 5:14:26 pm GMT

I am trying to bring back a value in column "B" after performing a vlookup function to determine that (sheet!absolute range does have a match with column AX2:AX4000 - for example)

So I think we are trying to do the same thing - Will an if then work and can someone provide an example? Thank you.

   
Reply to valid numbers
Ask your question Reply
They need your help