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.

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: