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

  • Thread starter Thread starter AMIT
  • Start date Start date
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
 
Back
Top