ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Worksheet Function - Find? (https://www.excelbanter.com/excel-worksheet-functions/14703-worksheet-function-find.html)

DAA

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.


Curt

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.



DAA

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.


.



All times are GMT +1. The time now is 08:48 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com