Drop-down box for name and address?

  • Thread starter Thread starter Sheila
  • Start date Start date
S

Sheila

I have an excel spreadsheet that was created by someone no
longer employeed with us. He created a spreadsheet that
contains the name, address, phone and fax of customers.
This info is used in a template. He is using the following
function, but I don't know what it means. Any help would
be appreciated.
Thanks in advance.
Sheila
 
and the function is?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Sorry, this is the function. =INT((RAND()*20+1)). I also
found this function in there that doesn't make sense to me
either if you could explain it to me. =VLOOKUP
(B25,Addresses!$A$1:$F$17,2)
 
Sheila,
=INT((RAND()*20+1)) is formula to generate a random number less than or equal to 20 but rounded to nearest whole number. also I'm pretty sure this will generate a new number everytime you edit a cell in the worksheet. Not too sure why you would use this tho!
=VLOOKUP(B25,Addresses!$A$1:$F$17,2)

Is looking up the value in cell B25 then matching it with the same value in column A in "Addresses and returning the value of Column B (2 denotes the 2nd column of Addresses!$A$1:$F$17)

if B25 = ABC
Addresses
A B
DFR 123
ABC 256

The result would be 256

Hope this helps

Harry
 
Harry,
Thanks so much for your help. I kind of thought that was
what happening with the VLOOKUP, but I couldn't put the
two together and figure out why they did what they did.
Thanks for your help, I really appreciate it.
Sheila
-----Original Message-----
Sheila,
=INT((RAND()*20+1)) is formula to generate a random
Click to expand...
number less than or equal to 20 but rounded to nearest
whole number. also I'm pretty sure this will generate a
new number everytime you edit a cell in the worksheet. Not
too sure why you would use this tho!
=VLOOKUP(B25,Addresses!$A$1:$F$17,2)

Is looking up the value in cell B25 then matching it with
Click to expand...
the same value in column A in "Addresses and returning the
value of Column B (2 denotes the 2nd column of Addresses!
$A$1:$F$17)
 
Back
Top