Hello All,
I am attempting to create an auto-populated form on the 'JRN Form' sheet. In cell D4 I can select a receipt number which represents a transfer of funds. These numbers correspond to the numbers in column A of 'Transfer Basic' sheet. Once I select the receipt number I would like the form to auto-populate with the correct information. The two areas that I can't figure out are the Receipt # column(B11:B18) and the Amount Transferred column (G11:G18). The 'Amount Transferred' column should return the amounts in order in the row of the 'Transfer Basic' sheet that corresponds to the value in cell D4 of the 'JRN Form' sheet. The 'Receipt #' column should return a value in row 1 of the 'Transfer Basic' sheet that corresponds to the amount returned in the 'Receipt #' column. For example, if I enter 15-046 into cell D4, B11 should return 14-034, G11 should return $203.31, B12 should return 14-035, and G12 should return $356.19.
I have tried various arrangements of INDEX and MATCH, VLOOKUP, etc. and can't get the right solution. Let me know if you need any more information.
Thanks in advance!
Ledger14-15test.xlsm
Bookmarks