create a named range somewhere e..g fruits
the range will be
apple 1
orange 2
bananas 3
in the columb B of your data type
=VLOOKUP(A15,fruits,2,FALSE)
as you enter in column A by validation list automatically the appropriate
index will be entered in column B.
==============================
SSR wrote in message
...
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
|