harpreet123
Board Regular
- Joined
- Nov 1, 2009
- Messages
- 61
Hi Experts
I have a situatuion where I have below information:
2150 ABC
2160 kjl
2150 mkn
2162 GHI
2160 HIK
and then I have a list of numbers
2150 ABC mkn
2160 kjl HIK
2162
Is there a formula which can return all variables of 2150 from first table
for ex :result I am looking for is mentioned in second table.
Thanks
H
I have a situatuion where I have below information:
2150 ABC
2160 kjl
2150 mkn
2162 GHI
2160 HIK
and then I have a list of numbers
2150 ABC mkn
2160 kjl HIK
2162
Is there a formula which can return all variables of 2150 from first table
for ex :result I am looking for is mentioned in second table.
Thanks
H