Two 'Look for Matches and return Values' Formulas required.

**hammer2** · 06-10-2016, 06:27 AM

Hi Folks

Couple of Formulas required to look for matches in separate sheets and if matched return the value from the same row.

Sample Workbook attached.

Cheers
hammer

**JohnTopley** · 06-10-2016, 06:32 AM

Try

=IFERROR(INDEX(Data!$Y$2:$Y$1000,MATCH(L2,Data!$A$2:$A$1000,0)),"")

=IFERROR(INDEX(Daily!$N$2:$N$1000,MATCH($A5,Daily!$L$2:$L$1000,0)),"")

**hammer2** · 06-10-2016, 08:20 AM

Great work Sir!

Thank you very much-
Cheers
hammer

**JohnTopley** · 06-10-2016, 08:25 AM

Thank for the feedback and rep. Could you please mark thread as solved("Thread Tools" at top of first post).

Two 'Look for Matches and return Values' Formulas required.

LinkBack

Thread Tools

Rate This Thread

Display

Two 'Look for Matches and return Values' Formulas required.

Re: Two 'Look for Matches and return Values' Formulas required.

Re: Two 'Look for Matches and return Values' Formulas required.

Re: Two 'Look for Matches and return Values' Formulas required.

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Formulas required to lookup Multiple Cols and return Values

Need excel formulas to return values for partial text matches

[SOLVED] 2 matches, search and return column values

[SOLVED] Finding Matches With Multiple Return Values

[SOLVED] Macro required to find matches and return value in the next column.

[SOLVED] Return sum of values in column when matching and also when Row matches input

Identify Matches and return values

Bookmarks

Bookmarks

Posting Permissions