Skip to main content
Support is Offline
Today is our off day. We are taking some rest and will come back stronger tomorrow
Official support hours
Monday To Friday
From 09:00 To 17:30
  Friday, 15 July 2022
  10 Replies
  5K Visits
0
Votes
Undo
Hi!

I'm trying to apply this → https://www.extendoffice.com/documents/excel/3730-excel-if-cell-contains-text-then-return-value-in-another-cell.html#kutools to multiple cells and I don't want to do it one by one. Any suggestions?
1 year ago
·
#2914
0
Votes
Undo
Hi, you should have applied validation restrictions on your cells. Follow the steps to clear them:
  1. Select the cell or cells that you want to remove validation from.
  2. Click Data > Data Tools > Data Validation.
  3. Click the Clear All button.
  4. Click OK.

Then please copy the formula in the cell D5 in the green table. If you cannot, take a screenshot of THE FORMULA IN D5.
Thanks.

Amanda


THANK YOU SO MUCH! It worked.
1 year ago
·
#2912
0
Votes
Undo
Hi, you should have applied validation restrictions on your cells. Follow the steps to clear them:
  1. Select the cell or cells that you want to remove validation from.
  2. Click Data > Data Tools > Data Validation.
  3. Click the Clear All button.
  4. Click OK.

Then please copy the formula in the cell D5 in the green table. If you cannot, take a screenshot of THE FORMULA IN D5.
Thanks.

Amanda
1 year ago
·
#2911
0
Votes
Undo
Hi there,

From the second picture, I don't see calories, protein, carbs, and fat values for the foods besides Bacond, cooked, so you cannot lookup the values for other foods in the green picture.

To get protein, carbs, and fat values for Bacond, cooked, you should make some of the cell references in the formula absolute by add the dollar sign ($). If you don't understand, please copy the formula in the intersection of Cal and Bacon, cooked.

And please, when you attach a picture, make sure the picture covers row numbers, column letters and formula bar as shown below:
[attachment]picture.png[/attachment]

Amanda


I also get the error message This value doesn't match the validation restrictions defined for this cell when I try to add dollar signs to the formula.
1 year ago
·
#2910
0
Votes
Undo
https://i.imgur.com/qBC55LK.png

https://i.imgur.com/2lCKIxa.png
1 year ago
·
#2909
0
Votes
Undo
Hi there,

From the second picture, I don't see calories, protein, carbs, and fat values for the foods besides Bacond, cooked, so you cannot lookup the values for other foods in the green picture.

To get protein, carbs, and fat values for Bacond, cooked, you should make some of the cell references in the formula absolute by add the dollar sign ($). If you don't understand, please copy the formula in the intersection of Cal and Bacon, cooked.

And please, when you attach a picture, make sure the picture covers row numbers, column letters and formula bar as shown below:
[attachment]picture.png[/attachment]

Amanda


When I try to copy the formula, I get this error message: This value doesn't match the validation restrictions defined for this cell

Here are the screencaps with the rows and column numbers and letters:

https://imgur.com/qBC55LK

https://imgur.com/2lCKIxa
1 year ago
·
#2903
0
Votes
Undo
Hi there,

From the second picture, I don't see calories, protein, carbs, and fat values for the foods besides Bacond, cooked, so you cannot lookup the values for other foods in the green picture.

To get protein, carbs, and fat values for Bacond, cooked, you should make some of the cell references in the formula absolute by add the dollar sign ($). If you don't understand, please copy the formula in the intersection of Cal and Bacon, cooked.

And please, when you attach a picture, make sure the picture covers row numbers, column letters and formula bar as shown below:
picture.png

Amanda
Attachments (1)
1 year ago
·
#2901
0
Votes
Undo
Hi there,

Can you show me screenshots of your data?

Amanda


https://i.imgur.com/vvvCESk.png
https://i.imgur.com/2GpDdoC.png

I'm trying to create a meal planner. What I want to happen is when I select a food item, the calories, protein, carbs, and fat content automatically fill in.
The first picture is where I'm trying to apply the function. The function worked for the column that says "54" but when I drag it to the right, I get "N/A"
The second picture is the table range that contains the lookup value and the result value.
1 year ago
·
#2898
0
Votes
Undo
Hi there,

Can you show me screenshots of your data?

Amanda
1 year ago
·
#2897
0
Votes
Undo
Hi,

Thanks for the advice. Unfortunately, that doesn't work. I get a "N/A".
1 year ago
·
#2890
0
Votes
Undo
Hi there,

After you apply the formula to a cell, you can drag the fill handle to fill the formula to other cells: https://support.microsoft.com/en-us/office/fill-a-formula-down-into-adjacent-cells-041edfe2-05bc-40e6-b933-ef48c3f308c6

Amanda
  • Page :
  • 1
There are no replies made for this post yet.