I'm trying to create a receipt as a separate tab in a workbook. I want to be able to type a reference number into one cell and have all of the information that is associated with that reference # fill into other cells. So that when I put in ref # 1234, the name, address, etc, of the person whose reference # that is will populate into all of the corresponding fields. I have tried vlookup, hlookup, as well as index, and have been unsuccessful. any advice is appreciated!
Bookmarks