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
 
Ad

Advertisements


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

Top