Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup returning value from antoher column in same row (Text!)
I am dealing with two worksheets in a large workbook. For the purposes of
public discussion, let's say: Sheet One has a column listing all the characters on The Wire, and a column that is blank or has a description of any beef that the row's character has with Omar. The second sheet has a list of all the characters who have died. I want a formula in a new column on Sheet Two that will reference Sheet one and pull the beef for each character. The list of names on Sheet One is longer so the names are not in the same order on both sheets. Also, the "Names" column is a different letter column on each sheet. This is not my workbook - I cannot use VBA, change settings, insert a pivot table, or move things around. The only thing I can do for my piece is insert a column on Sheet Two. (or cut and past from one to two everytime some changes something!) Example Sheet One Column A......Column B Frank Sobotka...[Is Blank] Prop Joe...........Stole my shipment D'Angelo...........Looked at me sideways Example Sheet Two Column D......Column K Frank Sobotka...[Is Blank] D'Angelo...........[Magical formula that I swear I knew at one time] How can this be accomplished? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup returning value from antoher column in same row (Text!)
Try this:
=IF(VLOOKUP(D2,Sheet1!A:B,2,0)="","",VLOOKUP(D2,Sh eet1!A:B,2,0)) -- Biff Microsoft Excel MVP "Cube Zombie" wrote in message ... I am dealing with two worksheets in a large workbook. For the purposes of public discussion, let's say: Sheet One has a column listing all the characters on The Wire, and a column that is blank or has a description of any beef that the row's character has with Omar. The second sheet has a list of all the characters who have died. I want a formula in a new column on Sheet Two that will reference Sheet one and pull the beef for each character. The list of names on Sheet One is longer so the names are not in the same order on both sheets. Also, the "Names" column is a different letter column on each sheet. This is not my workbook - I cannot use VBA, change settings, insert a pivot table, or move things around. The only thing I can do for my piece is insert a column on Sheet Two. (or cut and past from one to two everytime some changes something!) Example Sheet One Column A......Column B Frank Sobotka...[Is Blank] Prop Joe...........Stole my shipment D'Angelo...........Looked at me sideways Example Sheet Two Column D......Column K Frank Sobotka...[Is Blank] D'Angelo...........[Magical formula that I swear I knew at one time] How can this be accomplished? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup returning value from antoher column in same row (Text!)
Thanks so much. I was certain this had been a fairly simple nested function
but was tearing my hair out trying to remember which two functions it took! "T. Valko" wrote: Try this: =IF(VLOOKUP(D2,Sheet1!A:B,2,0)="","",VLOOKUP(D2,Sh eet1!A:B,2,0)) -- Biff Microsoft Excel MVP "Cube Zombie" wrote in message ... I am dealing with two worksheets in a large workbook. For the purposes of public discussion, let's say: Sheet One has a column listing all the characters on The Wire, and a column that is blank or has a description of any beef that the row's character has with Omar. The second sheet has a list of all the characters who have died. I want a formula in a new column on Sheet Two that will reference Sheet one and pull the beef for each character. The list of names on Sheet One is longer so the names are not in the same order on both sheets. Also, the "Names" column is a different letter column on each sheet. This is not my workbook - I cannot use VBA, change settings, insert a pivot table, or move things around. The only thing I can do for my piece is insert a column on Sheet Two. (or cut and past from one to two everytime some changes something!) Example Sheet One Column A......Column B Frank Sobotka...[Is Blank] Prop Joe...........Stole my shipment D'Angelo...........Looked at me sideways Example Sheet Two Column D......Column K Frank Sobotka...[Is Blank] D'Angelo...........[Magical formula that I swear I knew at one time] How can this be accomplished? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup returning value from antoher column in same row (Text!)
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Cube Zombie" wrote in message ... Thanks so much. I was certain this had been a fairly simple nested function but was tearing my hair out trying to remember which two functions it took! "T. Valko" wrote: Try this: =IF(VLOOKUP(D2,Sheet1!A:B,2,0)="","",VLOOKUP(D2,Sh eet1!A:B,2,0)) -- Biff Microsoft Excel MVP "Cube Zombie" wrote in message ... I am dealing with two worksheets in a large workbook. For the purposes of public discussion, let's say: Sheet One has a column listing all the characters on The Wire, and a column that is blank or has a description of any beef that the row's character has with Omar. The second sheet has a list of all the characters who have died. I want a formula in a new column on Sheet Two that will reference Sheet one and pull the beef for each character. The list of names on Sheet One is longer so the names are not in the same order on both sheets. Also, the "Names" column is a different letter column on each sheet. This is not my workbook - I cannot use VBA, change settings, insert a pivot table, or move things around. The only thing I can do for my piece is insert a column on Sheet Two. (or cut and past from one to two everytime some changes something!) Example Sheet One Column A......Column B Frank Sobotka...[Is Blank] Prop Joe...........Stole my shipment D'Angelo...........Looked at me sideways Example Sheet Two Column D......Column K Frank Sobotka...[Is Blank] D'Angelo...........[Magical formula that I swear I knew at one time] How can this be accomplished? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup is not returning the right value. | Excel Worksheet Functions | |||
lookup text in one column, count in another column | Excel Worksheet Functions | |||
Returning a text result from 2 lookup columns | Excel Discussion (Misc queries) | |||
connecting two Excel workbooks so one grabs info from antoher? | Excel Worksheet Functions | |||
Formula to lookup Multiple Column Text and then Count Result | Excel Worksheet Functions |