Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
A conditional lookup question.
Hey everyone, I think this is an easy question, but I can't figure it out...
Here goes nothing: There are two tabs. The first tab is a master list with eight columns. The seventh column, "G", will have values of "Y" or "N" The second tab would only return the rows from the first tab that have a "Y" for the value in column "G". Any ideas? I'm stumped... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
A conditional lookup question.
Try this:
=IF(Sheet1!G1="y",Sheet1!G12,"") Let me know if this helps. "Adam" wrote: Hey everyone, I think this is an easy question, but I can't figure it out... Here goes nothing: There are two tabs. The first tab is a master list with eight columns. The seventh column, "G", will have values of "Y" or "N" The second tab would only return the rows from the first tab that have a "Y" for the value in column "G". Any ideas? I'm stumped... |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
A conditional lookup question.
Hey Art, I'm kind of confused. Is this a value that I would put in one cell
or in multiple? I'm a newbie at excel. Thanks! PS: The name of the first sheet is "Master List". "art" wrote: Try this: =IF(Sheet1!G1="y",Sheet1!G12,"") Let me know if this helps. "Adam" wrote: Hey everyone, I think this is an easy question, but I can't figure it out... Here goes nothing: There are two tabs. The first tab is a master list with eight columns. The seventh column, "G", will have values of "Y" or "N" The second tab would only return the rows from the first tab that have a "Y" for the value in column "G". Any ideas? I'm stumped... |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
A conditional lookup question.
You do this to the whole amount that has values of y or n. For example:
If you have in the master list in column G Y's and N's down until row # 50. Them you put this formula in cell G1 in the second tab and then drag down untill row 50. (dragging is done, when you point the mouse over the right bottom corner of the cell untill you see a small plus sign). =IF('Master List'!A1="Y",'Master List'!A1,"") Let me know if you understand and it works. Good luck. "Adam" wrote: Hey Art, I'm kind of confused. Is this a value that I would put in one cell or in multiple? I'm a newbie at excel. Thanks! PS: The name of the first sheet is "Master List". "art" wrote: Try this: =IF(Sheet1!G1="y",Sheet1!G12,"") Let me know if this helps. "Adam" wrote: Hey everyone, I think this is an easy question, but I can't figure it out... Here goes nothing: There are two tabs. The first tab is a master list with eight columns. The seventh column, "G", will have values of "Y" or "N" The second tab would only return the rows from the first tab that have a "Y" for the value in column "G". Any ideas? I'm stumped... |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
A conditional lookup question.
Art,
Got it! Thanks! I dragged down and also to the right adjusting to the proper cell. A1 formula is: =IF('Master List'!$G$4="Y",'Master List'!A4,"") When I drag down it works perfectly, however, there are blank rows where the non "Y" rows are. Is there a way to automatically condense the results? "art" wrote: You do this to the whole amount that has values of y or n. For example: If you have in the master list in column G Y's and N's down until row # 50. Them you put this formula in cell G1 in the second tab and then drag down untill row 50. (dragging is done, when you point the mouse over the right bottom corner of the cell untill you see a small plus sign). =IF('Master List'!A1="Y",'Master List'!A1,"") Let me know if you understand and it works. Good luck. "Adam" wrote: Hey Art, I'm kind of confused. Is this a value that I would put in one cell or in multiple? I'm a newbie at excel. Thanks! PS: The name of the first sheet is "Master List". "art" wrote: Try this: =IF(Sheet1!G1="y",Sheet1!G12,"") Let me know if this helps. "Adam" wrote: Hey everyone, I think this is an easy question, but I can't figure it out... Here goes nothing: There are two tabs. The first tab is a master list with eight columns. The seventh column, "G", will have values of "Y" or "N" The second tab would only return the rows from the first tab that have a "Y" for the value in column "G". Any ideas? I'm stumped... |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
A conditional lookup question.
You can sort the column by using the filter and diselecting the blank cells.
"Adam" wrote: Art, Got it! Thanks! I dragged down and also to the right adjusting to the proper cell. A1 formula is: =IF('Master List'!$G$4="Y",'Master List'!A4,"") When I drag down it works perfectly, however, there are blank rows where the non "Y" rows are. Is there a way to automatically condense the results? "art" wrote: You do this to the whole amount that has values of y or n. For example: If you have in the master list in column G Y's and N's down until row # 50. Them you put this formula in cell G1 in the second tab and then drag down untill row 50. (dragging is done, when you point the mouse over the right bottom corner of the cell untill you see a small plus sign). =IF('Master List'!A1="Y",'Master List'!A1,"") Let me know if you understand and it works. Good luck. "Adam" wrote: Hey Art, I'm kind of confused. Is this a value that I would put in one cell or in multiple? I'm a newbie at excel. Thanks! PS: The name of the first sheet is "Master List". "art" wrote: Try this: =IF(Sheet1!G1="y",Sheet1!G12,"") Let me know if this helps. "Adam" wrote: Hey everyone, I think this is an easy question, but I can't figure it out... Here goes nothing: There are two tabs. The first tab is a master list with eight columns. The seventh column, "G", will have values of "Y" or "N" The second tab would only return the rows from the first tab that have a "Y" for the value in column "G". Any ideas? I'm stumped... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Question regarding lookup | Excel Discussion (Misc queries) | |||
Lookup or If, then Question | Excel Discussion (Misc queries) | |||
(V)LOOKUP question | Excel Worksheet Functions | |||
LOOKUP Question | Excel Discussion (Misc queries) | |||
Yet another lookup question | Excel Worksheet Functions |