- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Excel Help
Posted on 3/14/23 at 10:10 am
Posted on 3/14/23 at 10:10 am
Source:
Output:
Trying to return the percentage in row 2 of the source if the Item number and the Dates match on the output. If they don't, just return a blank or zero. Pretty sure it's going to use index/match. TIA
Output:
Trying to return the percentage in row 2 of the source if the Item number and the Dates match on the output. If they don't, just return a blank or zero. Pretty sure it's going to use index/match. TIA
2
Posted on 3/14/23 at 11:06 am to whiskey over ice
Sounds like a conditional format, but I would recommend asking ChatGPT, I learn new stuff on excel all the time by just asking it what I want.
Posted on 3/14/23 at 11:51 am to whiskey over ice
i would use index(match())
Posted on 3/14/23 at 12:48 pm to Gnar Cat21
I ended up just using match to get the column number and then used vlookup with the column number in one column and the percentage in the next. Only problem I have is where an item has the same month in more than one column so I’m not getting the two percentages. Just going to change one of the columns to the next month. Close enough for what I’m doing
Posted on 3/14/23 at 12:58 pm to whiskey over ice
=IFERROR(INDEX($B$2:$E$2,MATCH(1,(B6=$B$3:$E$3)*($A$7=$A$3),0)),"")
Use Ctrl+Shift+Enter after you type it in instead of Enter only.
Use Ctrl+Shift+Enter after you type it in instead of Enter only.
This post was edited on 3/14/23 at 1:01 pm
Posted on 3/15/23 at 6:29 am to whiskey over ice
quote:
Only problem I have is where an item has the same month in more than one column so I’m not getting the two percentages
This is why you use Index Match.
Page 1 of 1
Popular
Back to top
Follow TigerDroppings for LSU Football News