If statments

  • Thread starter Thread starter Lweiss
  • Start date Start date
L

Lweiss

I have a workbook with 2 spreadsheets, I want to create an if statment that
does the following.....
in workbook 2 cell A,if workbook 2 cell J contains the letter c then put
cell g from workbook c else null....

How can this be done??
 
Correction

If workbook 1 cell J contains the letter C then put cell G from workbook 1
in workbook 2 cell a else null.
 
Hi

Assuming that you want to compare values in row 1, try this formula in cell
A1 in sheet2.

=IF(Sheet1!J1="C";Sheet1!G1;"")

Regards,

Per
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combine IF Statments 2
Scrabble Value calculation for Welsh words 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Copy cells in Excel 1
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Multiple IF statment help 3
If statment help 3
VBA Code not working on Shared Workbook 3

Back
Top