On one sheet I have a name populating by a Data Variation from SHEET 2 and I would like the line below it to populate with some corresponding information in the cell next to it.
SHEET 1: IF ROW 11 = "Data Variation"
Then it will choose the corresponding cell to the right of the Data Variation information on SHEET 2, put it in ROW 12 and also populate ROW 14 with the NUMBER on SHEET 2.
So for example:
- ROW 11 I will use the drop down to choose TRUCK.
- It will then populate ROW 12 with the CORRESPONDING GREEN.
- Then in ROW 14 it will get 2000.
This maybe something straight forward, but I really only know the basics of this stuff.
So thank you in advance!