I am trying to create a spreadsheet that has a main page, lets say property
list page. On this page there are about 15 different columns that I need to
transfer, but I want them to transfer to another worksheet. I will have 13
other worksheets that will have transferred info on them. On the pages that
will receive the transferred info I want the cells to look according to the
buyers name. I will have a reference cell on the "buyers page" so that my
formula can search the buyers column. I can get the info to transfer over by
using the lookup formula but when I enter it in the cell below, to try to get
the next value, it changes all the returned values to the last one entered. I
cannot figure out how to make it ignore the ones that it has already returned
and go on to the next.