Solved

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

Posted on 2016-08-08
3
37 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 31

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

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

744 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

11 Experts available now in Live!

Get 1:1 Help Now