Remember Me?

#1
February 23rd 05, 07:56 PM
 DAA Posts: n/a
Worksheet Function - Find?

Hi,

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

#2
February 24th 05, 05:09 AM
 Curt Posts: n/a

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,

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

#3
February 24th 05, 05:15 PM
 DAA Posts: n/a

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,

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

.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Ken Wright Links and Linking in Excel 1 February 6th 05 05:58 PM freethrow18 Excel Worksheet Functions 1 February 2nd 05 06:38 AM Ralph Howarth Excel Worksheet Functions 4 January 19th 05 06:37 AM KitKat Excel Worksheet Functions 6 December 3rd 04 05:55 AM R. Hale Excel Worksheet Functions 3 November 25th 04 08:07 AM

All times are GMT +1. The time now is 04:21 PM.