linking a single cell to pull across various addresses

Varion

New Member
Joined
Sep 26, 2006
Messages
9
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

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

NBVC

Well-known Member
Joined
Aug 31, 2005
Messages
5,828
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

New Member
Joined
Sep 26, 2006
Messages
9
:) Lol thats a quick reply. Thx I'll try that tomoz in work.

Thx for the quick reply :)
 

Varion

New Member
Joined
Sep 26, 2006
Messages
9
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

Well-known Member
Joined
Aug 31, 2005
Messages
5,828
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

New Member
Joined
Sep 26, 2006
Messages
9
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 :)
 

Forum statistics

Threads
1,136,652
Messages
5,677,007
Members
419,668
Latest member
DharmaK

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top