Greetings,
I have been working on this for days and can not seem to find a solution. I have attached the file as an example. Basically, I am trying to have excel take a value from a cell and if it equals a certain number add the value in the next cell to a another cell. That was probably confusing.
Something like this.
If the value in column F = 2 then take the value in column G and add it to G23.
Please see the example. Any help would be awesome. Thanks.
In G21 use
=SUM(F21,INDEX($G$2:$G$7,MATCH(IFERROR(SUBSTITUTE(E21,"OY","")*1,E21),$F$2:$F$7,0)))
Copy down
Make sure Cell E21 has Base instead of Base:
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks