#### Varion

##### New Member
Hi all

Im trying to do an invoice sheet for the company I work for. I am using one worksheet with the invoice template to the left and a table to thr right numbered 1-30 with the suppliers name and address next to them.
I am trying to put a formula in a single cell in the invoice template which when I put a number in it (1-30) will drag the corresponding numbered address from the table to the right and drop it into the a larger cell as the address label.

Any help will be appreciated

### Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
Use Vlookup()....

=Vlookup(number,table,column index #,False)

where number is the cell reference housing the supplier number
table is the table range containing the number, name and address
column index # is the column number within the table to extract data from.

Lol thats a quick reply. Thx I'll try that tomoz in work.

Will this do multiple contacts in the same box. i.e. If I put 1 in it will bring supplier 1 across and if I put in 6 it will drag supplier 6 across, as I have used vlookup and it only seems to bring 1 address over

The formula I used from memory was

=vlookup(1,A2:B31,2,False)

Cheers

It will bring only the 1 supplier information matching the number you inputs. Depending on how you input your number(s) there could be various ways to handle extracting results.

If you post an actual example of what you are trying to accomplish and perhaps someone may have suggestions for you.

Use Colo's Html Maker (see link in my signature for instructions).

Ill have a go with the add in tommorrow late here.

I have 30 suppliers. I have one column running from 1-30 with the other column having the 30 suppliers. On the invoice sheet I have a singlecell in the top left next to a larger cell which will contain the address of the supplier. I want to be able to put each of the numbers 1-30 into the single cell drawing each of the addresses across into the larger cell, for whichever supplier I was invoicing.

Sory I f I cant make it any more clear. If I havnt ill try with the html tomoz
thx again

Replies
5
Views
153
Replies
1
Views
218
Replies
3
Views
150
Replies
3
Views
258
Replies
15
Views
795

1,221,153
Messages
6,158,237
Members
451,477
Latest member
CWebbers

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back