We want to retrieve the Price which is the SECOND column from our table array: +VLOOKUP (G15, $B$14:$D$17, 2, Place in the cell range of the Stock List: +VLOOKUP (G15, $B$14:$D$17,įrom which column do we want to retrieve the value? ![]() Reference the cell that contains the text or value: =VLOOKUP (G15,įrom which list are we doing a lookup on? STEP 3:We need to enter the Vlookup function: +VLOOKUP( įor the Source, ensure that it has the 4 Stock List values selected. ![]() STEP 2: Select List in the Allow dropdown.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |