linking a single cell to pull across various addresses

[Varion]

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

 

[NBVC]

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.

 

[Varion]

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

Thx for the quick reply

 

[Varion]

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

 

[NBVC]

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).

 

[Varion]

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