Hello, everyone
Let's say I have on column A the range of number and on column B the name of the ind. it correspondes to.
Is there any way to have a vlookup searching through the range on each cell and returning the ind.?
For instance, on cell A2 I would have 01-09 and cell B2 would say "Agriculture, Forestry, Fishing"
Thanks!
Let's say I have on column A the range of number and on column B the name of the ind. it correspondes to.
![DmvpnrP.png](/board/proxy.php?image=https%3A%2F%2Fi.imgur.com%2FDmvpnrP.png&hash=78f0cee00c66af6eeabb1420a3ba8a51)
Is there any way to have a vlookup searching through the range on each cell and returning the ind.?
For instance, on cell A2 I would have 01-09 and cell B2 would say "Agriculture, Forestry, Fishing"
Thanks!
Last edited: