Forum Discussion
kmichael24
Dec 04, 2020Copper Contributor
Excel
Hello there, I been struggling in get the formula and completing this question. Tiana Morales is the director of the customer call center for Pierce Software. For the past three months, she has ...
Riny_van_Eekelen
Dec 05, 2020Platinum Contributor
kmichael24 Perhaps something like this:
=HLOOKUP([@[Call Code]],CallTypes[#All],2,FALSE)
assuming that the cell where you enter this formula is also in a structured table.
- devs3c_Mar 22, 2021Copper Contributor
Riny_van_Eekelen only works partially, a lot of it doesnt work still unfortunately