I have a list of auction items, and as they are sold I will be filling in the
customer number next to the corresponding item (column headings are cust# and
item description). I want to be able to create a receipt from this data. I
have the receipt formatted and created. However, I am having trouble when a
user has multiple purchases because when I look up the data, I always only
find the first entry for a specific customer in the list. I think I need to
index the value some how, but I am not sure. Can someone help me out on the
formula I will need to use to return the next value in the table? Thank you,
I really appreciate the help.