Leather Mouse

Leather Mouse
Excel formula?

I have two columns with the following information: ………… 1 ………. 2 …………… 3 COL A: bat ….. cat ……….. cabbage leather B: six …… …. mouse col bag C: leather I need a formula for the "bag" in D by comparing C with a colleague result D: bag

assuming there are 3 values in each column, then it should contain cell D1: = VLOOKUP (INDEX (C1, 1), $ A $ 1: $ B $ 3,2) Fill down column D, and will everything ready. If you have more than three items in columns A and B, then change $ B $ 3 to $ B $ . This complete solution will have unpredictable results if Colum C contains values that are not in column B. You can also make it look prettier, switching to D1: = IF (C1 = VLOOKUP "","", (INDEX (C1, 1), $ A $ 1: $ B $ 3,2)) I think this is the second such question I answered for you today. Am I doing your homework for you?