Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2016-08-08
3
Medium Priority
?
52 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 47

Accepted Solution

by:
Wayne Taylor (webtubbs) earned 2000 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 33

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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
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 create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

715 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