User Profile
kallima_butterfly
Copper Contributor
Joined Oct 13, 2023
User Widgets
Recent Discussions
Re: I need excel to recognize what is in a cell and return the appropriate value from another cell
OliverScheurich Thank you so much. I changed the parameter a little but now I get "#N/A". Wondering where I went wrong? =INDEX('Tile & Civil'!$D$9:$M$48,MATCH($A$17,'Tile & Civil'!$A$9:$A$45,0),MATCH(1,('Tile & Civil'!$C$9:$C$48=K$17)*('Tile & Civil'!$D$8:$L$8=$B$17),0))1.2KViews0likes1CommentI need excel to recognize what is in a cell and return the appropriate value from another cell
Hi I am trying to build a spreadsheet where once a certain value is inputted it triggers 3 other cells to input the values corresponding to that value. It's a pay sheet. So I want to enter the trade that the worker is associated with and have the standard, overtime, and double time auto-populate in the cells next to it, using a table that is on another tab. I feel like it might be an "IF" formula but I keep getting?NAME error IF A17=BM, then J17 = Sheet22E22 I need to make the cell hold the formula for 24 trades. I would like the cell to also maybe reference whether its day or night shift (so a 2 parameter cell) IF A17 =B and A18 =Day, then J17=Sheet 22E221.4KViews0likes4Comments
Recent Blog Articles
No content to show