Efficiency of the lookup formula
I have some question about how efficient the lookup formula is
I have a situation where we when we have new items have the ability to give that item a mapping to another item to pull some initial data for since we don't have anything for it yet.
we used a lookup instead of just repopulating the initial data so the users can change there decision quickly themselves.
we have a formula like this for the item mapping, which because 99% of our items don't need mapping it ends up lookup up itself. it doesn't seem efficient to me,
but the alternative to leave the unmapped blank and have an if statement, checking for blank and only lookup when there is a value else pull just pull the value.
Which one is more efficient, or is there a better way of doing this
Best Answers
-
They early exit with the majority hitting the first parameter being blank would be the most performant.
0 -
@block blast, If 99% of items don't need mapping, there is another approach to reduce lookups. Using IF to check if a value exists before doing a lookup can save time. Have you tried any of these approaches?
0
Answers
-
Thank you for both your comments,
I had a feeling, the if statement to only lookup when I have a mapping was better but I'm still relatively new and wanted to check.0