Need help with VLookup Formula :(

Varion

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

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

barry houdini

MrExcel MVP
Joined
Mar 23, 2005
Messages
20,825
If your table is G2:H31 with numbers 1 to 30 in G2:G31 and corresponding addresses in H2:H31 then try this formula in B1

=VLOOKUP(A1,$G$2:$H$31,2,0)

where A1 contains the number (1-30) for which you want to return an address
 

Varion

New Member
Joined
Sep 26, 2006
Messages
9
Book1
BCDEFGH
3
4CodeSupliers
51bil
62dave
73alan
84etc
9Addresscell5etc
106etc
117etc
12Inputcell8etc
139etc
1410etc
1511etc
1612etc
1713etc
1814etc
1915etc
2016etc
2117etc
2218etc
2319etc
2420etc
2521etc
2622etc
2723etc
2824etc
2925etc
30
31
32
Sheet1
 

Varion

New Member
Joined
Sep 26, 2006
Messages
9

ADVERTISEMENT

oopps a bit big I think :oops:
 

NBVC

Well-known Member
Joined
Aug 31, 2005
Messages
5,828
To me it seems that you want the Vlookup() formula as I had suggested in your other thread

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

in this sample it would be =Vlookup(B12,G5:H29,2,False)

So that should work unless I am still not understanding your request.
 

Varion

New Member
Joined
Sep 26, 2006
Messages
9

ADVERTISEMENT

Okay guys ill try again with what your saying back again tomoz with a reply thanx for your time again :)
 

Varion

New Member
Joined
Sep 26, 2006
Messages
9
One last question if i do these formulas will it drop the address into the cell C9 or will it be B12 where I originally typed the number ?
 

NBVC

Well-known Member
Joined
Aug 31, 2005
Messages
5,828
One last question if i do these formulas will it drop the address into the cell C9 or will it be B12 where I originally typed the number ?

It will drop the address wherever you place the formula (as long as you don't place it in B12 or within your lookup table).
 

Forum statistics

Threads
1,141,679
Messages
5,707,787
Members
421,527
Latest member
Tamiwsw

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