How to compare data using index match with two condition

**devawad** · 04-23-2018, 08:28 AM

Dear Sir,

I have Datasheet in which I have my old prices of products in old prices sheet, and New prices in new prices sheet. I want to get new prices in old prices sheet, Using index match formula considering Customer name & item code as conditions.

Thanks in advance

Attached sample sheet for your reference.

Dev.

**63falcondude** · 04-23-2018, 08:33 AM

Try this in E2:

=INDEX('NEW PRICES'!D$2:D$890,INDEX(MATCH(A2&B2,'NEW PRICES'!A$2:A$890&'NEW PRICES'!B$2:B$890,0),0))

**FlameRetired** · 04-23-2018, 02:50 PM

Another way ... and with the understanding the Old prices are returned if no matches in 'NEW PRICES'.

Formula:

Please Login or Register  to view this content.

BTW in the sample file 63falcondude's formula is faster.

How to compare data using index match with two condition

LinkBack

Thread Tools

Rate This Thread

Display

How to compare data using index match with two condition

Re: How to compare data using index match with two condition

Re: How to compare data using index match with two condition

Thread Information

Users Browsing this Thread

Similar Threads

Using Index/Match (or other lookup),with an if condition to find data

Index match and (Compare)

Index match with condition

Sort index match if condition

Compare two lists and return matched values, including entire row data (Index/Match?)

Compare data with Index & Match function

Using INDEX, MATCH, but need condition

Bookmarks

Bookmarks

Posting Permissions