Stuck!

[kwilliams69]

LOL, Thank you in advance for answering my question. There are some really good excel pros around here!

Im having a problem linking additional information from a pull down list.

I have a list cell of restaurants from a pull down list in a sheet. The cells next to the restaurant cell have been set-up for the restaurants address, phone, type of food etc, which I have all organized in a seperate tab.
The problem is I don't know how to make all of the information fill the cells automatically next to it when the restaurant is chosen.

Sigh.. And of course I have a Monday deadline. LOL

 

[VoG]

You should be able to use VLOOKUP http://www.contextures.com/xlFunctions02.html

 

[wigi]

What a nice topic title you've picked out...

 

[kwilliams69]

Sorry everyone I forgot my password.
Thank you for the Vlookup feature.

Im on to the solution but sadly hit another block! SO

IN TAB ONE: I have 6 columns of information regarding my restaurant list. The 1st column is the name of every restaurant. The rows have all of the data that needs to be associated with the first column.

I get the message "the list source must be delimited" error when I try to save columns 2 - 6 as a list . SOmething is wrong with the group I saved. Any suggestions to a newbie? PLEASE thank you

 

[VoG]

I've never seen or heard of that error.

Example

<b>Sheet1</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td style=" border-width:3px; border-styleutset;border-color:#f0f0f0; ">A</td><td style=" border-width:3px; border-styleutset;border-color:#f0f0f0; ">B</td><td style=" border-width:3px; border-styleutset;border-color:#f0f0f0; ">C</td><td style=" border-width:3px; border-styleutset;border-color:#f0f0f0; ">D</td><td style=" border-width:3px; border-styleutset;border-color:#f0f0f0; ">E</td><td style=" border-width:3px; border-styleutset;border-color:#f0f0f0; ">F</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-styleutset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >1</td><td >Rest</td><td >Att1</td><td >Att2</td><td >Att3</td><td >Att4</td><td >Att5</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-styleutset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >2</td><td >X</td><td style="text-align:right; ">95</td><td style="text-align:right; ">34</td><td style="text-align:right; ">24</td><td style="text-align:right; ">28</td><td style="text-align:right; ">3</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-styleutset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >3</td><td >O</td><td style="text-align:right; ">45</td><td style="text-align:right; ">57</td><td style="text-align:right; ">45</td><td style="text-align:right; ">19</td><td style="text-align:right; ">30</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-styleutset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >4</td><td >Q</td><td style="text-align:right; ">7</td><td style="text-align:right; ">46</td><td style="text-align:right; ">57</td><td style="text-align:right; ">82</td><td style="text-align:right; ">60</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-styleutset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >5</td><td >A</td><td style="text-align:right; ">48</td><td style="text-align:right; ">81</td><td style="text-align:right; ">75</td><td style="text-align:right; ">19</td><td style="text-align:right; ">43</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-styleutset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >6</td><td >B</td><td style="text-align:right; ">20</td><td style="text-align:right; ">66</td><td style="text-align:right; ">9</td><td style="text-align:right; ">38</td><td style="text-align:right; ">53</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-styleutset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >7</td><td >W</td><td style="text-align:right; ">20</td><td style="text-align:right; ">79</td><td style="text-align:right; ">13</td><td style="text-align:right; ">80</td><td style="text-align:right; ">35</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-styleutset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >8</td><td >R</td><td style="text-align:right; ">8</td><td style="text-align:right; ">96</td><td style="text-align:right; ">19</td><td style="text-align:right; ">57</td><td style="text-align:right; ">99</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-styleutset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >9</td><td >Y</td><td style="text-align:right; ">9</td><td style="text-align:right; ">45</td><td style="text-align:right; ">97</td><td style="text-align:right; ">19</td><td style="text-align:right; ">39</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-styleutset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >10</td><td >N</td><td style="text-align:right; ">51</td><td style="text-align:right; ">42</td><td style="text-align:right; ">99</td><td style="text-align:right; ">12</td><td style="text-align:right; ">57</td></tr></table> <br />Excel tables to the web - Excel Jeanie Html 4

<b>Sheet2</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td style=" border-width:3px; border-styleutset;border-color:#f0f0f0; ">A</td><td style=" border-width:3px; border-styleutset;border-color:#f0f0f0; ">B</td><td style=" border-width:3px; border-styleutset;border-color:#f0f0f0; ">C</td><td style=" border-width:3px; border-styleutset;border-color:#f0f0f0; ">D</td><td style=" border-width:3px; border-styleutset;border-color:#f0f0f0; ">E</td><td style=" border-width:3px; border-styleutset;border-color:#f0f0f0; ">F</td><td style=" border-width:3px; border-styleutset;border-color:#f0f0f0; ">G</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-styleutset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >1</td><td >Rest:</td><td >A</td><td style="text-align:right; ">48</td><td style="text-align:right; ">81</td><td style="text-align:right; ">75</td><td style="text-align:right; ">19</td><td style="text-align:right; ">43</td></tr></table><br /><table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b>Spreadsheet Formulas</b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Cell</td><td >Formula</td></tr><tr><td >C1</td><td >=VLOOKUP($B1,Sheet1!$A1:$F10,2,FALSE)</td></tr><tr><td >D1</td><td >=VLOOKUP($B1,Sheet1!$A1:$F10,3,FALSE)</td></tr><tr><td >E1</td><td >=VLOOKUP($B1,Sheet1!$A1:$F10,4,FALSE)</td></tr><tr><td >F1</td><td >=VLOOKUP($B1,Sheet1!$A1:$F10,5,FALSE)</td></tr><tr><td >G1</td><td >=VLOOKUP($B1,Sheet1!$A1:$F10,6,FALSE)</td></tr></table></td></tr></table> <br />Excel tables to the web - Excel Jeanie Html 4

 

[kwilliams69]

ALMOT DONE!

I figured out my vlookup issues.

In one cell I have the vlookup string command and it work perfect. NOW how do I make the cell do additional functions?
EXAMPLE:
=VLOOKUP(A15,lvlookuprestgroup,6,FALSE) <------What do I add to the end of this to make another vlook command? Do i just type =vlook or is there suppose to be a & or different symbol to seperate the commands?