Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Worksheet Function - Find?
Hi,
Please help me figure this out. On worksheet 1, I would like to use a formula on Column C that if on worksheet 1 column B = Yes, it would copy the value on worksheet 2 column B as long as if the refers to the same names. Ex. On worksheet 1 column C row 2 would reflect 111 and on worksheet 1 column C row 4 would reflect 222. SAME WORKBOOK Worksheet 1 A B C 1 Apple No ??? 2 Banana Yes 3 Carrot No 4 Papaya Yes Worksheet 2 A B 1 Banana 111 2 Papaya 222 Please help. |
#2
|
|||
|
|||
DAA, Try this:
=IF(B2="yes",IF(A2=VLOOKUP(A2,Sheet3!$A:$A,1,FALSE ),VLOOKUP(A2,Sheet3!$A$1:$B$2,2,FALSE),""),"") The "Sheet3!" in the first vlookup formula represents the name of "worksheet 2". When using the vlookup's it's best to use the wizzard. ALWAYS USE FALSE at the end of a vlookup formula. The empty quotation marks represent a "no-response" or a blank reply to the vlookup. (I assumed that's what you wanted to do if the answer was no. -C "DAA" wrote: Hi, Please help me figure this out. On worksheet 1, I would like to use a formula on Column C that if on worksheet 1 column B = Yes, it would copy the value on worksheet 2 column B as long as if the refers to the same names. Ex. On worksheet 1 column C row 2 would reflect 111 and on worksheet 1 column C row 4 would reflect 222. SAME WORKBOOK Worksheet 1 A B C 1 Apple No ??? 2 Banana Yes 3 Carrot No 4 Papaya Yes Worksheet 2 A B 1 Banana 111 2 Papaya 222 Please help. |
#3
|
|||
|
|||
Perfect! Thanks a lot Curt.
-----Original Message----- DAA, Try this: =IF(B2="yes",IF(A2=VLOOKUP(A2,Sheet3! $A:$A,1,FALSE),VLOOKUP(A2,Sheet3!$A$1:$B$2,2,FALSE ),""),"") The "Sheet3!" in the first vlookup formula represents the name of "worksheet 2". When using the vlookup's it's best to use the wizzard. ALWAYS USE FALSE at the end of a vlookup formula. The empty quotation marks represent a "no-response" or a blank reply to the vlookup. (I assumed that's what you wanted to do if the answer was no. -C "DAA" wrote: Hi, Please help me figure this out. On worksheet 1, I would like to use a formula on Column C that if on worksheet 1 column B = Yes, it would copy the value on worksheet 2 column B as long as if the refers to the same names. Ex. On worksheet 1 column C row 2 would reflect 111 and on worksheet 1 column C row 4 would reflect 222. SAME WORKBOOK Worksheet 1 A B C 1 Apple No ??? 2 Banana Yes 3 Carrot No 4 Papaya Yes Worksheet 2 A B 1 Banana 111 2 Papaya 222 Please help. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
UDF and Calculation tree | Links and Linking in Excel | |||
for stats worksheet in XL how do i find the minitab function | Excel Worksheet Functions | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
ISNULL function - can't find it | Excel Worksheet Functions | |||
Find a Function to use accross different worksheets | Excel Worksheet Functions |