My Google Sheets

im having the same issue, tried all suggestions above the insert in h2 suggestion does work but all others do not

fixed

Did you try to copy this code?
=HLOOKUP(“name”, universe_types_type(INDIRECT(ADDRESS(ROW(), 8)), “en-us”, True), 2, FALSE)

I can see that you have number 6 in the ADDRESS function. That is for column position, so if you want to find name to type_id, you have to insert number 8 (type_id column) into that function.

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.