Vertical and Horizonal Look up

[pmw19800]

Hello ALL

Please see attached to help understanding

In column G on Order Status

I need a look up that looks at the part number in COL B and the date in G4... and the returns the data from the data stock sheet based on what data is in G4

I have entered expected results for the date of 25th


Paul

[KOKOSEK]

Into G7:

Please Login or Register  to view this content.

Merged cells, wrrr!.
Check attached file.


p.s. Look at : https://www.perfectxl.com/excel-tool...t-merge-cells/ or https://theexcelclub.com/stop-do-not...hy-with-fixes/

[Bo_Ry]

Please try

=IFNA(INDEX('STOCK 2022'!$E$4:$AE$191,MATCH(B7,'STOCK 2022'!$A$4:$A$191,),MATCH($G$4,'STOCK 2022'!$E$3:$AE$3,)),)