B
Brian S
I am trying to seperate data based on 2 lists and can't seem to wrap my head
around it. I want to take the item in List1 and pull all the corresponding
occurances in list 2. (assume each word is in a different column.) The
result should be a 3rd list for all the car charges and a 4th list for the
truck charges. I don't want to sort list2 either. I would like to compare
the first item in list1 to the items in list2 and then compare the 2nd item
in list1 to all the items in list2. Hope that question makes sense. Thanks.
Something like this:
List1
Car
Truck
List2
Car gas $$$$
Truck gas $$$$
Car oilchange $$$
Car tires $$$$
Truck tires $$$$
Thanks.
around it. I want to take the item in List1 and pull all the corresponding
occurances in list 2. (assume each word is in a different column.) The
result should be a 3rd list for all the car charges and a 4th list for the
truck charges. I don't want to sort list2 either. I would like to compare
the first item in list1 to the items in list2 and then compare the 2nd item
in list1 to all the items in list2. Hope that question makes sense. Thanks.
Something like this:
List1
Car
Truck
List2
Car gas $$$$
Truck gas $$$$
Car oilchange $$$
Car tires $$$$
Truck tires $$$$
Thanks.