Stuck!

kwilliams69

New Member
Joined
Jan 17, 2010
Messages
3
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
 
Last edited:

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
What a nice topic title you've picked out...
 
Upvote 0
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
 
Last edited:
Upvote 0
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-style:eek:utset;border-color:#f0f0f0; ">A</td><td style=" border-width:3px; border-style:eek:utset;border-color:#f0f0f0; ">B</td><td style=" border-width:3px; border-style:eek:utset;border-color:#f0f0f0; ">C</td><td style=" border-width:3px; border-style:eek:utset;border-color:#f0f0f0; ">D</td><td style=" border-width:3px; border-style:eek:utset;border-color:#f0f0f0; ">E</td><td style=" border-width:3px; border-style:eek:utset;border-color:#f0f0f0; ">F</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-style:eek:utset;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-style:eek:utset;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-style:eek:utset;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-style:eek:utset;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-style:eek:utset;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-style:eek:utset;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-style:eek:utset;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-style:eek:utset;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-style:eek:utset;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-style:eek:utset;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-style:eek:utset;border-color:#f0f0f0; ">A</td><td style=" border-width:3px; border-style:eek:utset;border-color:#f0f0f0; ">B</td><td style=" border-width:3px; border-style:eek:utset;border-color:#f0f0f0; ">C</td><td style=" border-width:3px; border-style:eek:utset;border-color:#f0f0f0; ">D</td><td style=" border-width:3px; border-style:eek:utset;border-color:#f0f0f0; ">E</td><td style=" border-width:3px; border-style:eek:utset;border-color:#f0f0f0; ">F</td><td style=" border-width:3px; border-style:eek:utset;border-color:#f0f0f0; ">G</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-style:eek:utset;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
 
Upvote 0
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?
 
Upvote 0

Forum statistics

Threads
1,213,551
Messages
6,114,266
Members
448,558
Latest member
aivin

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
Back
Top