Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Link To Drop Down Menu
I have a cell with a drop down menu with Contract Types. I want cells to
populate with data elsewhere on a worksheet if this drop down cell = T&M. Please see example below to better explain. Worksheet A A 1 T&M (drop down cell) 2 3 Tim Jones 4 Donna Jones 5 Jane Doe 6 John Black Worksheet B A 1 if A1 in Worksheet A = T&M I want this cell to equal A3 from worksheet A 2 if A1 in Worksheet A = T&M I want this cell to equal A4 from worksheet A 3 if A1 in Worksheet A = T&M I want this cell to equal A5 from worksheet A 4 if A1 in Worksheet A = T&M I want this cell to equal A6 from worksheet A If A1 is not = to T&M, I'd like A1:A4 to be left blank Thanks! Jana |
#2
|
|||
|
|||
Link To Drop Down Menu
=if(isblank(a1),"",vlookup(yourvlookuphere))
Here's VLOOKUP: http://www.officearticles.com/excel/...soft_excel.htm and here's a very closely related tutorial: http://www.officearticles.com/tutori...soft_excel.htm ************ Anne Troy www.OfficeArticles.com "JANA" wrote in message ... I have a cell with a drop down menu with Contract Types. I want cells to populate with data elsewhere on a worksheet if this drop down cell = T&M. Please see example below to better explain. Worksheet A A 1 T&M (drop down cell) 2 3 Tim Jones 4 Donna Jones 5 Jane Doe 6 John Black Worksheet B A 1 if A1 in Worksheet A = T&M I want this cell to equal A3 from worksheet A 2 if A1 in Worksheet A = T&M I want this cell to equal A4 from worksheet A 3 if A1 in Worksheet A = T&M I want this cell to equal A5 from worksheet A 4 if A1 in Worksheet A = T&M I want this cell to equal A6 from worksheet A If A1 is not = to T&M, I'd like A1:A4 to be left blank Thanks! Jana |
#3
|
|||
|
|||
Link To Drop Down Menu
In WorksheetB, A1, put
=IF(WorksheetA!A1="T&M",WorksheetA!A2,"") and copy down as far as you need. |
#4
|
|||
|
|||
Link To Drop Down Menu
Thanks Anne, but I still can't get this to work. I tried VLOOKUP before I
posted the question, but it won't work. There is no problem with arguement 1, that should = A1. However in the example you sent me the range for Arguement 2 must contain a column with the value in Arguement 1. I don't have this in my example. In my case my range would be A3:A6 for the data I want to pull, but there is no column with with the A2 data (in this case T&M in that range). Therefore, I don't have a number to put in for Arguement 3 either. Maybe I'm misunderstanding, but if a Vlookup formula is possible, can you please give me an example of the formula I would use given the data in my example below. =if(isblank(a1),"",vlookup(A1,A3:A6,1) - this doesn't work Please note that in the real spreadsheet I'm using T&M is not really in cell A1, but somewhere else on the spreadsheet like in cell W14. I put it in A1 in the example for simplicity. Thanks I would appreciate your help again - I'm getting very frustrated trying to get this to work. Jana "Anne Troy" wrote: =if(isblank(a1),"",vlookup(yourvlookuphere)) Here's VLOOKUP: http://www.officearticles.com/excel/...soft_excel.htm and here's a very closely related tutorial: http://www.officearticles.com/tutori...soft_excel.htm ************ Anne Troy www.OfficeArticles.com "JANA" wrote in message ... I have a cell with a drop down menu with Contract Types. I want cells to populate with data elsewhere on a worksheet if this drop down cell = T&M. Please see example below to better explain. Worksheet A A 1 T&M (drop down cell) 2 3 Tim Jones 4 Donna Jones 5 Jane Doe 6 John Black Worksheet B A 1 if A1 in Worksheet A = T&M I want this cell to equal A3 from worksheet A 2 if A1 in Worksheet A = T&M I want this cell to equal A4 from worksheet A 3 if A1 in Worksheet A = T&M I want this cell to equal A5 from worksheet A 4 if A1 in Worksheet A = T&M I want this cell to equal A6 from worksheet A If A1 is not = to T&M, I'd like A1:A4 to be left blank Thanks! Jana |
#5
|
|||
|
|||
Link To Drop Down Menu
Send the file, girl. :)
anne@ (the website below) ************ Anne Troy www.OfficeArticles.com "JANA" wrote in message ... Thanks Anne, but I still can't get this to work. I tried VLOOKUP before I posted the question, but it won't work. There is no problem with arguement 1, that should = A1. However in the example you sent me the range for Arguement 2 must contain a column with the value in Arguement 1. I don't have this in my example. In my case my range would be A3:A6 for the data I want to pull, but there is no column with with the A2 data (in this case T&M in that range). Therefore, I don't have a number to put in for Arguement 3 either. Maybe I'm misunderstanding, but if a Vlookup formula is possible, can you please give me an example of the formula I would use given the data in my example below. =if(isblank(a1),"",vlookup(A1,A3:A6,1) - this doesn't work Please note that in the real spreadsheet I'm using T&M is not really in cell A1, but somewhere else on the spreadsheet like in cell W14. I put it in A1 in the example for simplicity. Thanks I would appreciate your help again - I'm getting very frustrated trying to get this to work. Jana "Anne Troy" wrote: =if(isblank(a1),"",vlookup(yourvlookuphere)) Here's VLOOKUP: http://www.officearticles.com/excel/...soft_excel.htm and here's a very closely related tutorial: http://www.officearticles.com/tutori...soft_excel.htm ************ Anne Troy www.OfficeArticles.com "JANA" wrote in message ... I have a cell with a drop down menu with Contract Types. I want cells to populate with data elsewhere on a worksheet if this drop down cell = T&M. Please see example below to better explain. Worksheet A A 1 T&M (drop down cell) 2 3 Tim Jones 4 Donna Jones 5 Jane Doe 6 John Black Worksheet B A 1 if A1 in Worksheet A = T&M I want this cell to equal A3 from worksheet A 2 if A1 in Worksheet A = T&M I want this cell to equal A4 from worksheet A 3 if A1 in Worksheet A = T&M I want this cell to equal A5 from worksheet A 4 if A1 in Worksheet A = T&M I want this cell to equal A6 from worksheet A If A1 is not = to T&M, I'd like A1:A4 to be left blank Thanks! Jana |
#6
|
|||
|
|||
Link To Drop Down Menu
Hi
You are missing the Sheet references. =if(isblank(Sheet1!$A$1),"",vlookup($A3,Sheet1!$A$ 3:$A$6,1,0) You need the 4th argument in VLOOKUP, FALSE or 0 because your data in Sheet1!A3:A6 is not in alphabetic order. You also need to make your ranges Absolute, so they don't alter as you copy the formula down the sheet. Regards Roger Govier JANA wrote: Thanks Anne, but I still can't get this to work. I tried VLOOKUP before I posted the question, but it won't work. There is no problem with arguement 1, that should = A1. However in the example you sent me the range for Arguement 2 must contain a column with the value in Arguement 1. I don't have this in my example. In my case my range would be A3:A6 for the data I want to pull, but there is no column with with the A2 data (in this case T&M in that range). Therefore, I don't have a number to put in for Arguement 3 either. Maybe I'm misunderstanding, but if a Vlookup formula is possible, can you please give me an example of the formula I would use given the data in my example below. =if(isblank(a1),"",vlookup(A1,A3:A6,1) - this doesn't work Please note that in the real spreadsheet I'm using T&M is not really in cell A1, but somewhere else on the spreadsheet like in cell W14. I put it in A1 in the example for simplicity. Thanks I would appreciate your help again - I'm getting very frustrated trying to get this to work. Jana "Anne Troy" wrote: =if(isblank(a1),"",vlookup(yourvlookuphere)) Here's VLOOKUP: http://www.officearticles.com/excel/...soft_excel.htm and here's a very closely related tutorial: http://www.officearticles.com/tutori...soft_excel.htm ************ Anne Troy www.OfficeArticles.com "JANA" wrote in message ... I have a cell with a drop down menu with Contract Types. I want cells to populate with data elsewhere on a worksheet if this drop down cell = T&M. Please see example below to better explain. Worksheet A A 1 T&M (drop down cell) 2 3 Tim Jones 4 Donna Jones 5 Jane Doe 6 John Black Worksheet B A 1 if A1 in Worksheet A = T&M I want this cell to equal A3 from worksheet A 2 if A1 in Worksheet A = T&M I want this cell to equal A4 from worksheet A 3 if A1 in Worksheet A = T&M I want this cell to equal A5 from worksheet A 4 if A1 in Worksheet A = T&M I want this cell to equal A6 from worksheet A If A1 is not = to T&M, I'd like A1:A4 to be left blank Thanks! Jana |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with drop down menu | Excel Worksheet Functions | |||
How to create a drop down menu which referencing a different workb | Excel Discussion (Misc queries) | |||
How do I set up a drop down menu within a drop down menu? | Excel Discussion (Misc queries) | |||
Drop down menu | Excel Discussion (Misc queries) | |||
link drop down menu to info in worksheet | New Users to Excel |