Check out some problems solved by our top Experts or click here to post your own problem for free!

Working with two workbooks, the formula I need is going to look up the value in workbook 1 in a large range in workbook 2 (columns a-c and if it finds it and it meets a specific value in column 2, then bring back the value in column 3. How do I achieve this? Workbook 2 columns 2 and 3 are alphanumeric

Solved by I. J. in 30 mins

I would like to have Excel look at a cell and if there is any # in it, to automatically add a new row below the current row and copy the previous row and paste it in the new row. If there is nothing in the target call, then do nothing. I dont know if it can do this, can it be done?

Solved by T. U. in 48 mins

I am making a conversion chart. the formula I am using is =IF(C31<>0,(C31-29.7)/131.8+B31,""). This outputs to column D. This way, if column C is blank, the formula is ignored. If column B has a value, but column C does not, I want to ignore the formula and simply have column D equal Column B. If both C and B have a value, I want to run the formula which alters C and adds B.

Solved by F. Y. in 33 mins

I got an error message "reference isn't valid"
I was trying to group two objects when it happened. The error message has me locked up. If I close it and click on anything else in excel it pops up again

Solved by G. D. in 58 mins

how to apply incremental charges if any amount increased
Suppose A1 contains 175000 and after every increment of 50000 we have to charge $40. How do we do it

Solved by X. U. in 20 mins

Do I have to pay for a solution ? I just wasted time with another help desk that asked for $46 for an answer. If that is the case, thanks anyway.

Solved by X. U. in 18 mins

I have 3 columns e.g.:
Due Offered Actual
16/05/19 16/04/19 10/05/19
What I need is if the "Offered" date is after the "Due" date the box changes colour. Sadly I cannot seem to figure out the formula for the variables. I'd also need "Actual" to do a similar thing based on due date.

Solved by T. D. in 22 mins

i am trying to make a box change colors based on another boxes value. the issue is I need it to change based on multiple boxes depending on which one is most recent. example, box c4 is white unless box f4 is red, then it turns red as well, however if box g4 is green then c4 is no longer red but instead turns back to white.

Solved by C. Q. in 51 mins

I want a formula which says if x =" y" or "z" or "whatever" multiple a by either "x" or "y" but get a VALUE error- any ideas?
=PRODUCT(IF('Historical data'!I5="Research Associate",Costs!$B$18*'Historical data'!F5),PRODUCT(IF('Historical data'!I5="Senior Research Associate A",Costs!$C$18*'Historical data'!F5),PRODUCT(IF('Historical data'!I5="Senior Research Associate B",Costs!$D$18*'Historical data'!F5),PRODUCT(IF('Historical data'!I5="Freelancers",Costs!$E$18*'Historical data'!F5),PRODUCT(IF('Historical data'!I5="Research Director",Costs!$F$18*'Historical data'!F5),PRODUCT(IF('Historical data'!I5="Company Director",Costs!$G$18*'Historical data'!F5),PRODUCT(IF('Historical data'!I5="Managing Director",Costs!$H$18*'Historical data'!F5),"")))))))

Solved by V. Y. in 20 mins

If I want to write a formula that states" "If this name shows up K24, and this word shows up in J24 pull this number from M24" I can creat that formula - however I need to drag this down so it pulls from row 24 - 60 - is there way to do this?

Solved by F. D. in 40 mins

Trusted by people who work at