Solved

Excel Formula to copy values from one tabs cell to another tabs cell when matching

Posted on 2016-08-08
3
43 Views
Last Modified: 2016-08-28
I have a workbook with two tabs

Schedule & sites

I would like column E of Schedule to be same as column A of sites if  Schedule column A has a match in sites column d... If there is no match Column E should remain blank
0
Comment
Question by:Matt Pinkston
  • 2
3 Comments
 
LVL 47

Accepted Solution

by:
Wayne Taylor (webtubbs) earned 500 total points (awarded by participants)
ID: 41748110
I think I understand your requirements. Try this formula in cell E2 of the Schedule worksheet and copy down as required.

   =IFERROR(INDEX(Sites!A:A, MATCH(A2, Sites!D:D, 0)), "")

Next time, please post an example workbook.
1
 
LVL 32

Expert Comment

by:Rob Henson
ID: 41748387
Not for points!! Wayne, I agree with your interpretation of the requirement and would do the same.
1
 
LVL 47

Expert Comment

by:Wayne Taylor (webtubbs)
ID: 41773576
As recommended by Rob Henson
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

930 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now