Last answered:

18 May 2022

Posted on:

17 May 2022

0

Exercises - Offset and match

formula :  =OFFSET(B5,MATCH($B19,$B$6:$N$10,0),1)

Result.

$ in thousands Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Store B #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A

Hi,

I dont understand why my formula looks correct but my result keep showing #N/A. How can I get this fixed?

1 answers ( 0 marked as helpful)
Instructor
Posted on:

18 May 2022

0

Hi Martin,
Can you please share a screenshot of your workbook, so I can take a better look?
Thanks!

Submit an answer