![]() ![]() By pressing f4, we can create a formula for absolute referencing. Select the table array as A3 to B8 and make them absolute reference Absolute Reference Absolute reference in excel is a type of cell reference in which the cells being referred to do not change, as they did in relative reference.Ok, let’s open the VLOOKUP function in the E2 cell.So using these subject names in table 2, we need to fetch the data from table 1. In table 1, we have the subject list and their respective scores, and in table 2, we have some subject names, but we don’t have scores for them.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |