how to use if formula in list (data validation list)

A

AMIT

A HAVE NUMBERS LIKE A1,A2,A3, B HAVE NUMBERS LIKE B1,B2,B3, C HAVE NUMBERS
LIKE C1,C2,C3.
I MADE 2 LIST (A,B,C) & (A1,A2,A3,B1,B2,B3,C1,C2,C3)

IF IN 1 CELL I USE 1ST LIST "DATA VALIDATION"- "LIST"( A,B,C) & SELECT A
OUT OF A,B,C

THEN I WANT IN NEXT CELL WHERE I M USING 2ND LIST(A1,A2,A3,B1,..) , IT SHOW
ONLY NUMBER A1,A2,A3
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

multiplication of two array in a particular way 2
concatenate with arrays 4
Copying data from 205 columns to 1 column 4
Turning rows of equal number of columns into 1 continuous row 1
Linking cell ranges between rows and columns 1
Cell entry 2
Can a cell be turned on or off? 1
Copy Excel functions formula and auto refresh refresh 3

Top