steiny0831
New Member
- Joined
- Oct 18, 2013
- Messages
- 34
Hi there,
Am running into a problem with a spread sheet I am working on.
I attached a link to a test page I am working on.
What I need it to do is -
If cell A2 is equal to any word in the range of G1:G4 and B2 is 11 then I need it to return "yes" in C2, if not it needs to return the value of B2 in cell C2.
I cant get it to work in trying a range of cells in G1:G4, it will only work if I have the word color itself in the formula. But need it to work in a range of cells.
Below is a shared sheet with the top not working and bottom working but only by word color in formula.
Not sure if this makes sense.
https://docs.google.com/spreadsheets/d/1abFq3aAR2UoF9Vd0akuEFcafFINDwvXAK_dZmkV_1Gw/edit?usp=sharing
Thank you for any help!
Am running into a problem with a spread sheet I am working on.
I attached a link to a test page I am working on.
What I need it to do is -
If cell A2 is equal to any word in the range of G1:G4 and B2 is 11 then I need it to return "yes" in C2, if not it needs to return the value of B2 in cell C2.
I cant get it to work in trying a range of cells in G1:G4, it will only work if I have the word color itself in the formula. But need it to work in a range of cells.
Below is a shared sheet with the top not working and bottom working but only by word color in formula.
Not sure if this makes sense.
https://docs.google.com/spreadsheets/d/1abFq3aAR2UoF9Vd0akuEFcafFINDwvXAK_dZmkV_1Gw/edit?usp=sharing
Thank you for any help!