Text from two different cells to give value shown in certain cel
Solved/Closed
Related:
- Text from two different cells to give value shown in certain cel
- Excel macro to create new sheet based on value in cells - Guide
- If cell contains date then return value ✓ - Office Software Forum
- How would you change all cells containing the word pass to green - Excel Forum
- Conditional formatting if cell contains text - Excel Forum
- Excel if range of cells contains specific text then return value ✓ - Excel Forum
2 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Jan 2, 2017 at 07:02 AM
Jan 2, 2017 at 07:02 AM
fgadim, Good morning.
Please next time show us your example file.
This helps us to help you.
Following your instructions I set an example:
https://www.sendspace.com/file/mrx4h7
Try this formula:
C1 --> =INDEX($C$6:$G$57, MATCH(B1,$B$6:$B$57,0), MATCH(A1,$C$5:$G$5,0))
Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Please next time show us your example file.
This helps us to help you.
Following your instructions I set an example:
https://www.sendspace.com/file/mrx4h7
Try this formula:
C1 --> =INDEX($C$6:$G$57, MATCH(B1,$B$6:$B$57,0), MATCH(A1,$C$5:$G$5,0))
Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Jan 2, 2017 at 10:02 AM
Jan 2, 2017 at 10:02 AM
fgadmin, Good afternoon.
This is not a problem.
You wanted to find a value according to 2 conditions.
I created a solution according to your request and there was nothing in it about adding selections.
To do something with filter does not need formula.
See Plan 2 of the worksheet.
https://www.sendspace.com/file/7i68s8
I hope it helps.
This is not a problem.
You wanted to find a value according to 2 conditions.
I created a solution according to your request and there was nothing in it about adding selections.
To do something with filter does not need formula.
See Plan 2 of the worksheet.
https://www.sendspace.com/file/7i68s8
I hope it helps.
Updated by fgadmin on 2/01/17 at 08:11 AM
Thank you a lot this helps a lot.
Only issue here is if I want to combine the numbers say if I wanted it to add Week 5 + Week 11 and Week 20 in the result. Like in a filter.
Say pick weeks 1-4 and it shows the total from those weeks.
Jan 2, 2017 at 11:25 AM