79589856

Date: 2025-04-24 05:27:05
Score: 1.5
Natty:
Report link
=indirect(vlookup(a1,$i$8:$j$13,2,false))

in my case I use: =INDIRECT(UNIQUE('Data Validation'!$E$2:$E$25,FALSE,TRUE))

I have tried this but it throws an error: "The source currently evaluates to an error. Do you want to continue?"

Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Contains question mark (0.5):
  • Low reputation (1):
Posted by: Jhaa Lee UTP