Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If/Then function in excel
Hello Everyone, It's been a while...
I have 2 questions, i'm gonna ask the first one now then the second one later. The Setup: I have an excel workbooke with 2 sheets. The first sheet is named "Bowl Assembly" and the second sheet is named "Power Unit. In the sheet "Bowl Assembly" row i has a series of headers and data entry cells. The cells in 'Bowl Assembly' row i that have values are (cells: i4,5,6 cells: i9-16 and cells:i19-36) these cells can be empty, or can have the values: "PUEP 2" "PUEP 3" to "PUEP 12". These fields are completed by me for data entry. The fields directly to the right lists a company. for example, cell 'Bowl Assembly'i4 = PUEP 11 the cell directly to the right may = "Company A" The second sheet "Power Unit" has a list starting at A4, with the terms "PUEP 2" to "PUEP 12". What I want is the cells directly to the right to have the value directly to the right in the sheet 'Bowl Assembly' Example: 'Bowl Assembly'i14 = PUEP 9 and 'Bowl Assembly' j14 = Company A As stated, the PUEP's are listed in sheet 'Power Unit' so, in sheet 'Power Unit' a11 there is a value of "PUEP 9" I want 'Power Unit' b11 to equal "Company A" If someoene could help me with this if/then scenario it would be appreciated. Thanks, Kevin |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
If/Then function in excel
Keep it to one specific question per thread, make it attractive for
responders to respond. You can start as many new threads as you have queries Here's one interp on your question here, it might suffice In Power Unit, Put in B4: =IF(ISNA(MATCH(A4,'Bowl Assembly'!I:I,0)),"",INDEX('Bowl Assembly'!J:J,MATCH(A4,'Bowl Assembly'!I:I,0))) Copy down -- Max Singapore http://savefile.com/projects/236895 Downloads:22,500 Files:370 Subscribers:66 xdemechanik --- "Kevin M" wrote: The Setup: I have an excel workbook with 2 sheets. The first sheet is named "Bowl Assembly" and the second sheet is named "Power Unit. In the sheet "Bowl Assembly" row i has a series of headers and data entry cells. The cells in 'Bowl Assembly' row i that have values are (cells: i4,5,6 cells: i9-16 and cells:i19-36) these cells can be empty, or can have the values: "PUEP 2" "PUEP 3" to "PUEP 12". These fields are completed by me for data entry. The fields directly to the right lists a company. for example, cell 'Bowl Assembly'i4 = PUEP 11 the cell directly to the right may = "Company A" The second sheet "Power Unit" has a list starting at A4, with the terms "PUEP 2" to "PUEP 12". What I want is the cells directly to the right to have the value directly to the right in the sheet 'Bowl Assembly' Example: 'Bowl Assembly'i14 = PUEP 9 and 'Bowl Assembly' j14 = Company A As stated, the PUEP's are listed in sheet 'Power Unit' so, in sheet 'Power Unit' a11 there is a value of "PUEP 9" I want 'Power Unit' b11 to equal "Company A" If someoene could help me with this if/then scenario it would be appreciated. Thanks, Kevin |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
If/Then function in excel
thanks... worked perfectly.
"Max" wrote: Keep it to one specific question per thread, make it attractive for responders to respond. You can start as many new threads as you have queries Here's one interp on your question here, it might suffice In Power Unit, Put in B4: =IF(ISNA(MATCH(A4,'Bowl Assembly'!I:I,0)),"",INDEX('Bowl Assembly'!J:J,MATCH(A4,'Bowl Assembly'!I:I,0))) Copy down -- Max Singapore http://savefile.com/projects/236895 Downloads:22,500 Files:370 Subscribers:66 xdemechanik --- "Kevin M" wrote: The Setup: I have an excel workbook with 2 sheets. The first sheet is named "Bowl Assembly" and the second sheet is named "Power Unit. In the sheet "Bowl Assembly" row i has a series of headers and data entry cells. The cells in 'Bowl Assembly' row i that have values are (cells: i4,5,6 cells: i9-16 and cells:i19-36) these cells can be empty, or can have the values: "PUEP 2" "PUEP 3" to "PUEP 12". These fields are completed by me for data entry. The fields directly to the right lists a company. for example, cell 'Bowl Assembly'i4 = PUEP 11 the cell directly to the right may = "Company A" The second sheet "Power Unit" has a list starting at A4, with the terms "PUEP 2" to "PUEP 12". What I want is the cells directly to the right to have the value directly to the right in the sheet 'Bowl Assembly' Example: 'Bowl Assembly'i14 = PUEP 9 and 'Bowl Assembly' j14 = Company A As stated, the PUEP's are listed in sheet 'Power Unit' so, in sheet 'Power Unit' a11 there is a value of "PUEP 9" I want 'Power Unit' b11 to equal "Company A" If someoene could help me with this if/then scenario it would be appreciated. Thanks, Kevin |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
If/Then function in excel
Welcome, pl mark responses which help by pressing the YES buttons (like the
one below). -- Max Singapore http://savefile.com/projects/236895 Downloads:22,500 Files:370 Subscribers:66 xdemechanik --- "Kevin M" wrote: thanks... worked perfectly. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help to build a Look Up Function or What Ever Function Excel 2002 | Excel Worksheet Functions | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
challenge! javascript function into excel function | Excel Worksheet Functions | |||
Excel Workday Function with another function | Excel Discussion (Misc queries) | |||
Can you nest a MID function within a IF function in Excel | Excel Worksheet Functions |