Help

[kaylaS]

I have 2 sheets in my workbook. If b2(sheet1) is equal to any cell in column a(sheet2), then I need D (sheet2) to equal d42 (sheet1)

 

[dermie_72]

This is not super clear, but I'll give it a crack. Assuming you want Sheet2, D2 to equal Sheet1, D42 IF Sheet1,B2 is also in Sheet2, Column A????? Again your issue is not super clear, so having to assume.
If this is true then the formula in Sheet2, D2 would be:

=IF(COUNTIFS(Sheet2!$A:$A,Sheet1!B2)<>0,Sheet1!$D$42,"")

 

[kaylaS]

This is not super clear, but I'll give it a crack. Assuming you want Sheet2, D2 to equal Sheet1, D42 IF Sheet1,B2 is also in Sheet2, Column A????? Again your issue is not super clear, so having to assume.
If this is true then the formula in Sheet2, D2 would be:

=IF(COUNTIFS(Sheet2!$A:$A,Sheet1!B2)<>0,Sheet1!$D$42,"")

This is not super clear, but I'll give it a crack. Assuming you want Sheet2, D2 to equal Sheet1, D42 IF Sheet1,B2 is also in Sheet2, Column A????? Again your issue is not super clear, so having to assume.
If this is true then the formula in Sheet2, D2 would be:

=IF(COUNTIFS(Sheet2!$A:$A,Sheet1!B2)<>0,Sheet1!$D$42,"")

I have 2 sheets in my workbook. I would like to find a formula so that if b2 on (sheet1) is equal to the value on any of the cells in column a from (sheet2), colum F will = the formula that I have set on (sheet1) D42.

This one has been tricky

 

[dermie_72]

Could you post an example of your data and what you hope to achieve? Or upload an XL2BB file with the information

 

[kaylaS]

upload an XL2BB file

Could you post an example of your data and what you hope to achieve? Or upload an XL2BB file with the information

The hope is if b1 on calc matches any on sample job code column the total $ that is calculated on calc will populate into the corresponding column on sample

 

[dermie_72]

See if this formula works for you.

=IF(Calculator!B$1=Sample!A2,Calculator!D$42,0)

 

[kaylaS]

See if this formula works for you.

=IF(Calculator!B$1=Sample!A2,Calculator!D$42,0)

Yes!!! This worked, thank you.

 

[Joe4]

kaylaS,

Please Note: In the future, when marking a post as the solution, please mark the post that contains the solution (not your own post acknowledging that some other post was the solution).
When a post is marked as the solution, it is then shown right underneath the original question so people viewing the question can easily see the question and solution in a single quick glance without having to hunt through all the posts.

I have updated this thread for you.

 

[kaylaS]

Yes!!! This worked, thank you.

See if this formula works for you.

=IF(Calculator!B$1=Sample!A2,Calculator!D$42,0)[/CODE
[/QUOTE]

When I change the # in b1 is changed the # doesn't save in the corresponding column on sheet 2, I have tried locking the cell but that isn't working, any thoughts?