I have a lookup table similar to below:
id object channel 1 2 8665 1 3 8364 1 4 0 2 1 0 2 5 8763 2 8 8310 3 10 41367 3 12 45171
I have another table similar to the below that has another id column (id 2). This is actually created from another table elsewhere in my workbook. I want the table belows object 2’s and channel 2’s column to be taken from the above table excluding the rows with 0 for the channels. It would look like this....
id 2 object 2 channel 2 1 2 8665 1 3 8364 2 5 8763 2 8 8310
Can you help me with a formula to use in the channel 2 column of my second table to fill in from the channel column in the first table excluding zeros. Im assuming this would incorporate a vlookup.
Bookmarks