Lookup Function from a Series Table Data

[Irfan149]

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

[#2]

@Irfan149 

Hi there,

Please find attached Excel file and picture of solution.

I hope it will help you.

[#3]

@Ilgar_Zarbaliyev 

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.

[#4 · Accepted solution]

 @Ilgar_Zarbaliyev 

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