OrochiNoob
New Member
- Joined
- May 8, 2019
- Messages
- 20
Hello to all
So Im trying to accomplish 2 things, I have a table that was poorly formatted were I need to get information 50+ times a day
I was able to get the information but there are comments on SOME cells,
This is what I got so far
1st DropDown ( Main Category )
2nd Indirect Dropdown ( Second Category )
Vlookup to look for the Indirect result
I need help getting the comments from the Vllokup result to and adjacent cell
A
1 Main Drop Selection
2 Indirect DropdownSelection
A B C
10 Field1 Vlookup Indirect DropdownSelection / Comments TO STRING original Cell
11 Field2 Vlookup Indirect DropdownSelection / Comments TO STRING original Cell
12 Field3 Vlookup Indirect DropdownSelection / Comments TO STRING original Cell
13 Field4 Vlookup Indirect DropdownSelection / Comments TO STRING original Cell
C10:C13 Are missing
Super Thank you in advanced
So Im trying to accomplish 2 things, I have a table that was poorly formatted were I need to get information 50+ times a day
I was able to get the information but there are comments on SOME cells,
This is what I got so far
1st DropDown ( Main Category )
2nd Indirect Dropdown ( Second Category )
Vlookup to look for the Indirect result
I need help getting the comments from the Vllokup result to and adjacent cell
A
1 Main Drop Selection
2 Indirect DropdownSelection
A B C
10 Field1 Vlookup Indirect DropdownSelection / Comments TO STRING original Cell
11 Field2 Vlookup Indirect DropdownSelection / Comments TO STRING original Cell
12 Field3 Vlookup Indirect DropdownSelection / Comments TO STRING original Cell
13 Field4 Vlookup Indirect DropdownSelection / Comments TO STRING original Cell
C10:C13 Are missing
Super Thank you in advanced