mobilesuit818
New Member
- Joined
- Sep 13, 2006
- Messages
- 48
Hello,
This is my formula =INDEX($H$22:$H$24,ROW($C19)-18,MATCH($B$19,0))&""
I know that have this incorrrect. This is what I am trying to do.
@B19 if the value is Metal%, then @C19, it would show a data validation box with data from H21:H24.
Please advise.
This is my formula =INDEX($H$22:$H$24,ROW($C19)-18,MATCH($B$19,0))&""
I know that have this incorrrect. This is what I am trying to do.
@B19 if the value is Metal%, then @C19, it would show a data validation box with data from H21:H24.
Please advise.