Hi,
I want to do a vertical lookup in an Excel sheet.
Let's say my formula is in cell A1.
I want to write a number in cell A2. The lookup in cell A1 will check in a list from B1 to B50. When it finds the same value in that range, I want the lookup to display the value from the cell just right of it, in the column C.
So for example, I write 1995 in A2. The lookup in A1 finds it at B10 and in A1 (where's the lookup formula), the value of cell C10 is displayed.
Thanks for any help!
Werner