SOLVED

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

@Irfan149 

Hi there,

Please find attached Excel file and picture of solution.

I hope it will help you.

 

@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.

 

Microsoft Community.PNG

best response confirmed by Irfan149 (New Contributor)
Solution

 @Ilgar_Zarbaliyev 

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

 

Microsoft Community.PNG