Hey, I'm having an issue with lookup. I have a look up function (say lookup 'x','range of x','range of y') where x is the lookup and y is the result. There are multiple values for y, and I need to create a formula which will dynamically list these Y's, so that if new data is added to the database, it'll automatically be added. Can anyone help with this? I've done some googling and see that by using Index and dragging down, it's possible, but this isn't practical for me, as I need it to be dynamic.