Match Three Columns to Return a Value in another Column

**MotorcycleGuy** · 06-19-2017, 07:18 PM

Hello,

I'm new here and relatively new to Excel Formulas and I need help. I'm trying to Match Three Columns (A, D & E) from Sheet2 with Sheet1 to return an updated value from Column F on Sheet2 to Sheet1. I've been trying to do this for a little while now and I can't figure it out. Any help would be much appreciated.

**FlameRetired** · 06-19-2017, 07:35 PM

Hi MotorcycleGuy. Welcome to the forum.

I'm not real clear on this part.

return an updated value from Column F on Sheet2 to Sheet1.

Is it Sheet1 that gets the formula? Updated how?

**FlameRetired** · 06-19-2017, 07:50 PM

In the meantime see the attached. This formula returns what was hand typed in column F. In F3 and filled down.

Formula:

Please Login or Register  to view this content.

Is this what you had in mind?

Match Three Columns to Return a Value in another Column

LinkBack

Thread Tools

Rate This Thread

Display

Match Three Columns to Return a Value in another Column

Re: Match Three Columns to Return a Value in another Column

Re: Match Three Columns to Return a Value in another Column

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Need to match two columns and return a third column value from a table

compare two columns and return match from third column

Match 1st and 2nd columns in 2 sheets and return 3rd,4th and 5th column if match.

Match 3 set of columns and return value from another column in case of a unique match.

Excel 2007 : how to match 2 columns and return value from the 3rd column

Match 2 columns in 2 sheets and return the 3rd column

Excel 2007 : Match 2 columns to return the value of the third column

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions