The lookup worth as well as supply info are different details sorts. As an example, you try to acquire VLOOKUP reference a amount, however the resource info is saved as text.The IFNA function returns the value you specify if a formula returns the #N/A error price; or else it returns the result of the formulation.INDEX and MATCH are fantastic choic