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

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
Matt PinkstonAsked:
Who is Participating?
Wayne Taylor (webtubbs)Connect With a Mentor Commented:
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.
Rob HensonFinance AnalystCommented:
Not for points!! Wayne, I agree with your interpretation of the requirement and would do the same.
Wayne Taylor (webtubbs)Commented:
As recommended by Rob Henson
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.