Last answered:

28 Mar 2023

Posted on:

25 Mar 2023

0

Resolved: Index Match Match Issue

Hi all,


I faced an issue, that the return number is different of what indexed in the data sheet.


Check please the photos below:



I should return with the Value of 156.9



Could you check for me, what could be the issue, cus I could not trust this Formula.


Br,


Yasser

3 answers ( 1 marked as helpful)
Instructor
Posted on:

27 Mar 2023

0

Hi Yasser, please use a formula that points to the column H only. As your function's first argument you shuold have H4:H4573. Please try to do that and let's see if the function works. 

Posted on:

27 Mar 2023

0

Hi Ned,


Thanks for your response,

I did it like that

^^=INDEX('Orders info'!H4:J4573,MATCH(C3,'Orders info'!I:I,0),MATCH('2.'!B5,'Orders info'!H:H,0))^^


I got N/A.


I you could provide me with the correct written one, so I can apply, hence state the issue


Instructor
Posted on:

28 Mar 2023

0

Hi,

Please try with:

=INDEX('Orders info'!H4:H4573,MATCH(C3,'Orders info'!I:I,0),MATCH('2.'!B5,'Orders info'!H:H,0))


The first argument should not be pointing to two columns. 

Submit an answer