Index Match Required

**cliffo** · 01-21-2019, 08:23 PM

Hi,

I need help with the attached excel function.

I want to be able to type in a function into the yellow highlighted cell which says "Excel Function needed here".

I want to match the cells B5,A5, and B20 from 'Data' Sheet to Columns B,C,D from 'Data2' Sheet to get the 'Price' column from 'Data 2' to show in 'Data.

Let me know if this is not clear enough. I have highlighted in yellow everything that is needed i think.

Thanks

**teylyn** · 01-21-2019, 08:59 PM

Hello,

try in cell K5

=INDEX('Data 2'!$M$1:$M$100,MATCH(Data!$B$20&Data!A5&Data!B5,INDEX('Data 2'!$B$1:$B$100&'Data 2'!$C$1:$C$100&'Data 2'!$D$1:$D$100,0),0))

Adjust the row references to suit the data in Data 2. Don't use that formula with whole columns, because it will be really slow.

Copy down.

**cliffo** · 01-21-2019, 10:58 PM

That worked great. Thanks

Index Match Required

LinkBack

Thread Tools

Rate This Thread

Display

Index Match Required

Re: Index Match Required

Re: Index Match Required

Thread Information

Users Browsing this Thread

Similar Threads

Help with index and / or match formula with multiple match required to return a value

Required Index Match with If function

[SOLVED] Index & Match help required

[SOLVED] Help required with match and index functions

[SOLVED] Formula required (Index, Match)

Index Match only 4 results required

Excel 2007 : INDEX/MATCH help required

Bookmarks

Bookmarks

Posting Permissions