ExcelBanter - if-then functions

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - if-then functions (https://www.excelbanter.com/excel-worksheet-functions/263828-if-then-functions.html)

Becky

if-then functions

I have a two sheet workbook. If 'sheet 1 B7' contains a certain word I want
"Sheet2 B2' to return the value in 'Sheet 1 B8". Can I do this? How?
Thanx

Lars-Åke Aspelin[_4_]

if-then functions

On Fri, 14 May 2010 12:15:01 -0700, Becky
wrote:

I have a two sheet workbook. If 'sheet 1 B7' contains a certain word I want
"Sheet2 B2' to return the value in 'Sheet 1 B8". Can I do this? How?
Thanx

Yes you can. Please see your other thread with the same question.

Lars-Åke

Shane Devenshire[_2_]

if-then functions

In sheet2 cell B2 enter the formula

=IF(Sheet1!B7="certain word",Sheet1!B8,"")

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"Becky" wrote:

I have a two sheet workbook. If 'sheet 1 B7' contains a certain word I want
"Sheet2 B2' to return the value in 'Sheet 1 B8". Can I do this? How?
Thanx

All times are GMT +1. The time now is 07:20 AM.