Lookup List to Index

[SSR]

Hello,

I have a sheet with 2 columns as Below
A B
1 Apples 1
2 Oranges 3
3 Bannanas 2

Cells in Column A have data validation with values say
Apples
Bannanas
Oranges

What I want in Cells of Column B is the Index i,e the Number 1 or 2 or 3 as
and when "Apples" or "Bannanas" or "Oranges" are selected


is this possible without using any macro but with Worksheet formulas?

Regards,
SSR

 

[Bob Phillips]

It is if you put the items in a table elsewhere on the sheet, say H1:H10,
and use that range in your DV list. Then in B1 use

=MATCH(A1,H1:H10,0)