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)
Ned Krastev
Instructor
Hi Martin,
Can you please share a screenshot of your workbook, so I can take a better look?
Thanks!