Match clolumn a and b with with column e and row f2:j2

[pavlos_x]

some help please how to MATCH CLOLUMN A AND B WITH WITH COLUMN E AND ROW F2:J2
result should be taken from F3:J16
thank you
calculate.xls

[Ali Kırksekiz]

Please Login or Register  to view this content.

[pavlos_x]

amazing thank you, how about the if there is nothing on a or b columns to return zero or empty

[Ali Kırksekiz]

Please Login or Register  to view this content.

[JohnTopley]

=iferror(index(f3:j16,match(a2,e3:e16,0),match(b2,f2:j2,0)),"")

[pavlos_x]

THANK YOU both its great

[Tony Valko]

What version of Excel does this have to work in?

The sample file is in *.xls format but your profile says you're using Excel 2010.

[pavlos_x]

THAT IS a sample file, my actual file is xlsm, am using office 2010.
actually i modified the code to this because the coma does not work, so am using this (
=IFERROR(INDEX($BU$85:$CL$112;MATCH(D12;$BT$85:$BT$112;0);MATCH(E12;$BU$83:$CL$83;0))

[Tony Valko]

Here's another one based on the sample file.

=IFERROR(VLOOKUP(A2;E3:J16;MATCH(B2;E2:J2;0);0);"")