![]() Note that if I type your formula in your spreadsheet, it returns #NAME?.Īnd if I drag drop down with the cross from the right bottom corner your XLOOKUP cell, the new cells at the bottom also return #NAME? ![]() Yes, when I open the XLOOKUP file you sent me, it does work, and I get '3' as a result.īut when I noticed that you added '_xlfn.' in the beginning of the formula (=_xlfn.XLOOKUP(F3 B4:B9 C4:C9 ""), I wanted to copy it, in order to ask you why, but XLOOKUP stopped working and returned #NAME? instead of '3'.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |