# Need help with VLookup Formula :(

#### Varion

##### New Member
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.

### Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
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

Book1
BCDEFGH
3
4CodeSupliers
51bil
62dave
73alan
84etc
106etc
117etc
12Inputcell8etc
139etc
1410etc
1511etc
1612etc
1713etc
1814etc
1915etc
2016etc
2117etc
2218etc
2319etc
2420etc
2521etc
2622etc
2723etc
2824etc
2925etc
30
31
32
Sheet1

oopps a bit big I think

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.

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

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 ?

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

Replies
6
Views
204
Replies
9
Views
285
Replies
1
Views
287
Replies
6
Views
700
Replies
5
Views
137

1,218,888
Messages
6,145,016
Members
450,585
Latest member
airc72

### 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