Hello,
New to the forum as i am in desparate need of some help.

This may be quite hard to explain

my formula is - and this is the exact code

=INDEX(SalesPipelineDetails,MATCH(1,IF('Sales Performance (Top 5)'!C8 = 'Sales Pipeline Details'!C:C,'Sales Pipeline Details'!AO:AO,0),0),4)


this returns an N/A#
SalesPipelinedetails is a named range

for the row - MATCH(1,IF('Sales Performance (Top 5)'!C8 = 'Sales Pipeline Details'!C:C,'Sales Pipeline Details'!AO:AO,0),0) will return row 6500,

and then column is 4

If i highlight the formular in the formula bar and press f9 it returns the correct answer, however in the cell it returns N/a

can any one help

Thanks

Andy