Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 23rd 05, 06:56 PM
DAA
 
Posts: n/a
Default 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   Report Post  
Old February 24th 05, 04:09 AM
Curt
 
Posts: n/a
Default

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   Report Post  
Old February 24th 05, 04:15 PM
DAA
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
UDF and Calculation tree Ken Wright Links and Linking in Excel 1 February 6th 05 04:58 PM
for stats worksheet in XL how do i find the minitab function freethrow18 Excel Worksheet Functions 1 February 2nd 05 05:38 AM
Weekly Transaction Processing Ralph Howarth Excel Worksheet Functions 4 January 19th 05 05:37 AM
ISNULL function - can't find it KitKat Excel Worksheet Functions 6 December 3rd 04 04:55 AM
Find a Function to use accross different worksheets R. Hale Excel Worksheet Functions 3 November 25th 04 07:07 AM


All times are GMT +1. The time now is 01:02 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017