Lookup Function from a Series Table Data

New Contributor

Hi, I have data in a table (Table Array) and want to get value (Lookup Value) with specific number from the series (Table Array).  


Microsoft Community.PNG

3 Replies


Hi there,

Please find attached Excel file and picture of solution.

I hope it will help you.



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.


Microsoft Community.PNG

best response confirmed by Irfan149 (New Contributor)


I've got the solution. We can use Lookup function by using vector option. I've attached the picture. Thank you. 


Microsoft Community.PNG