Page 247 - CITS - Computer Software Application -TT

COMPUTER SOFTWARE APPLICATION - CITS

We got some errors as #N/A in the cells E6, E8, and E9. If we look at the ranges for these cells, it does not include
the values against those IDs.

ID 156 is not in the range from A6 to B13; we got an error. Similarly, for the remaining two cells, we have the same
issue.
How to Fix the #N/A! ERROR Issue?
We need to make this an absolute reference when referencing a table range.

We must press the F4 key to make it an absolute reference.

234

CITS : IT&ITES - Computer Software Application - Lesson 63 - 77