![]() ![]() The syntax of the INDIRECT() function is: = INDIRECT(ref_text,) (Here is a link to a guide to using the INDIRECT() function.) This function gets the right address from a cell or text reference. The INDIRECT() function comes in handy here. In order to make the formula dynamic to account for the different Divisions, the table_array part of the formula should be revised. However, when this formula is pulled down to C8, we get the same value since our tab is fixed to Game Div. In this example, we want an exact match.Ĭell C6 =VLOOKUP($B$4,’Game Div.’!$A$4:$B$24,2,FALSE)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |