Forum Discussion
LookupValue if error help
Fairly new to Power Bi so looking for some help. Below is the formula in columns I am using: =iferror(Lookupvalue(), "No Found") However, it is returning blanks. When looking in the other sh...
Hey,
You can use IFERROR(LOOKUPVALUE,’’NOT FOUND’’)
Make sure you replace ‘lookupvalue’ with the actual lookup expression that you want to search for in sheet1.
Do pass the parameters while using Lookup value
And it will display ‘not found’ instead of returning a blank value.
Hope this will help