Dec 21 2021 12:34 AM
Hi, I have data in a table (Table Array) and want to get value (Lookup Value) with specific number from the series (Table Array).
Dec 21 2021 02:06 AM
Dec 21 2021 09:55 PM
Hi Dear,
It seems okay but if there is lookup value not belongs to data I want N/A. I've attached the picture in orange color.
Dec 21 2021 11:01 PM
SolutionI've got the solution. We can use Lookup function by using vector option. I've attached the picture. Thank you.
Dec 21 2021 11:01 PM
SolutionI've got the solution. We can use Lookup function by using vector option. I've attached the picture. Thank you.