INDEX formula with another criteria

[ExcelRoy]

Hi all,

I am trying to use the following formula but need to add 2 separate MATCH commands

The first will be look in Column B for C4 data the look in column H for D4 the return the data in column I

here's what I have so far

=IFERROR(INDEX(Backorders!$I$2:$I$10000,MATCH(C4,Backorders!$B$2:$B$10000,0),0),"")

Many thanks

 

[njimack]

Confirm with Ctrl+Shift+Enter:
=IFERROR(INDEX(Backorders!$I$2:$I$10000,MATCH(C4&D4,Backorders!$B$2:$B$10000&Backorders!$H$2:$H$10000,0)),"")

 

[ExcelRoy]

Hi njimack,

doesn't seem to show anything?

Thanks

 

[ExcelRoy]

Edit: my bad, works a treat

Many thanks for your help