Try entered with Ctrl+Shift+Enter:

=INDEX(Amendments!$G$2:$G$10000,MATCH(1,($C$10=Ame ndments!$A$2:$A$10000)*(C21=Amendments!$F$2:$F$100 00),0))

HTH

"CMO" wrote:

Hi,

I've been trying to use the INDEX function to lookup values in 1 column
based on 2 others. The formula I have is below, but the result I'm getting
is "#N/A". I have confirmed the formula using Ctrl+Shift+Enter, but that
doesn't seem to have helped.

Formula -
=INDEX(Amendments!$G$2:$G$10000,MATCH($C$10&$C$21, Amendments!$A$2:$A$10000&Amendments!$F$2:$F$10000, 0))

C10 is a field containing a number and C21 is a field containing a date.

All help will be much appreciated!

Thx

Chris