Hi all
Im trying to create a worksheet which will have an invoice sheet to the left of the screen and a table for suppliers addresses to the right numbered 1-30. Within the invoice sheet I have tried to create a formula within a single cell,which when you put a number from 1-30 in it will drop the corresponding address from the table to the right into a larger cell within the invoice part of the worksheet.
ive posted this request before and was told to use =Vlookup(1,B2:B31,True) which I did put it only pulls across a single address from the table. I need the formula to enable toput whatever number in between 1-30 and drag the the equivalent numbered address across.
Thx in advance
Im trying to create a worksheet which will have an invoice sheet to the left of the screen and a table for suppliers addresses to the right numbered 1-30. Within the invoice sheet I have tried to create a formula within a single cell,which when you put a number from 1-30 in it will drop the corresponding address from the table to the right into a larger cell within the invoice part of the worksheet.
ive posted this request before and was told to use =Vlookup(1,B2:B31,True) which I did put it only pulls across a single address from the table. I need the formula to enable toput whatever number in between 1-30 and drag the the equivalent numbered address across.
Thx in advance