Using 2 lists to obtain a result from a 3rd list. (using the AND function for the first 2 lists I think). How do I relate the 3rd list to the first 2?
This is just a very small portion of the lists.
Example: If list1 entry is 21, and List2 entry is 6.5, then I want the result to be, say, 3. How can I relate these lists?
I hope I have explained my problem sufficiently. Can anyone assist with this enquiry.
Regards.....gsdanger.
List1 | List2 | List3 | List1Input | 21 | |||
20 | 5 | 2 | List2Input | 6.5 | |||
21 | 5.5 | 2.5 | |||||
22 | 6 | 3 | List3result | ?? | |||
23 | 6.5 | 3.5 | |||||
24 | 7 | 4 | |||||
25 | 7.5 | 4.5 |
Example: If list1 entry is 21, and List2 entry is 6.5, then I want the result to be, say, 3. How can I relate these lists?
I hope I have explained my problem sufficiently. Can anyone assist with this enquiry.
Regards.....gsdanger.