|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 21st, 2009, 12:22 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Function and pulling data across
Hi would like to find out, what should the formula be like if i wanted to
pull data from cell 1 from worksheet A to worksheet B if data from cell 2 of worksheet A is true. The formula i have so far looks like this. "=IF('A'!F10="X", "'B'!B3='A'!B10'", "") However, the result i get if 'A'!F10="X" is B'!B3='A'!B10'. The alternative to that situation would be to change the formule to "=IF('A'!F10="X", '"B'!B3='A'!B10"', "") However, the result would an error with B10"' portion. Any ideas on where to go from here? Thanks a million in advance! 
|
|
#2
April 21st, 2009, 12:56 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Function and pulling data across
Maybe you meant this:
Enter this formula in worksheet B, cell B3: =IF(A!F10="X",A!B10,"") Regards, Stefi „Ivan Koh” ezt *rta: Hi would like to find out, what should the formula be like if i wanted to pull data from cell 1 from worksheet A to worksheet B if data from cell 2 of worksheet A is true. The formula i have so far looks like this. "=IF('A'!F10="X", "'B'!B3='A'!B10'", "") However, the result i get if 'A'!F10="X" is B'!B3='A'!B10'. The alternative to that situation would be to change the formule to "=IF('A'!F10="X", '"B'!B3='A'!B10"', "") However, the result would an error with B10"' portion. Any ideas on where to go from here? Thanks a million in advance!
|
|
#3
April 22nd, 2009, 05:18 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Function and pulling data across
Hi Stefi,
Thanks for the reply, but i think you missed out on the '' for the worsksheets. No matter, it works just fine for me now! Thanks Ivan "Stefi" wrote: Maybe you meant this: Enter this formula in worksheet B, cell B3: =IF(A!F10="X",A!B10,"") Regards, Stefi „Ivan Koh” ezt *rta: Hi would like to find out, what should the formula be like if i wanted to pull data from cell 1 from worksheet A to worksheet B if data from cell 2 of worksheet A is true. The formula i have so far looks like this. "=IF('A'!F10="X", "'B'!B3='A'!B10'", "") However, the result i get if 'A'!F10="X" is B'!B3='A'!B10'. The alternative to that situation would be to change the formule to "=IF('A'!F10="X", '"B'!B3='A'!B10"', "") However, the result would an error with B10"' portion. Any ideas on where to go from here? Thanks a million in advance!
|
|
#4
April 22nd, 2009, 08:08 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Function and pulling data across
Apostroph (') is not always needed around the worksheet name, only if it
contains spaces. A!F10 and 'A'!F10 are equivalent but A sheet!F10 must be written as 'A sheet'!F10 . You are welcome! Thanks for the feedback! Clicking the YES button will be appreciated. Stefi „Ivan Koh” ezt *rta: Hi Stefi, Thanks for the reply, but i think you missed out on the '' for the worsksheets. No matter, it works just fine for me now! Thanks Ivan "Stefi" wrote: Maybe you meant this: Enter this formula in worksheet B, cell B3: =IF(A!F10="X",A!B10,"") Regards, Stefi „Ivan Koh” ezt *rta: Hi would like to find out, what should the formula be like if i wanted to pull data from cell 1 from worksheet A to worksheet B if data from cell 2 of worksheet A is true. The formula i have so far looks like this. "=IF('A'!F10="X", "'B'!B3='A'!B10'", "") However, the result i get if 'A'!F10="X" is B'!B3='A'!B10'. The alternative to that situation would be to change the formule to "=IF('A'!F10="X", '"B'!B3='A'!B10"', "") However, the result would an error with B10"' portion. Any ideas on where to go from here? Thanks a million in advance!
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
