![]() ![]() ![]() ![]() It does not work when copied into column G. We have used the following XLOOKUP function in cell F2 to return the Name and Department for each ID from the table on the left, named staff. Let’s look at an example where this behaviour is not desirable. However, when this formula is filled to the right for English and Art. It looks like an absolute reference as it explicitly reads Grades table and the Maths column – Grades. In the following example, the AVERAGE function has been used in cell F3 to average the scores for Maths. This is a surprise to many users as a table reference looks absolute. By default, table references are relative, so they change. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |