LinkBack URL
About LinkBacks
Hi
How can I compare the data of two columns, and if the same, to show me the number from a third column?
I upload a quick sample
Thank you for helping
Hi
How can I compare the data of two columns, and if the same, to show me the number from a third column?
I upload a quick sample
Thank you for helping
You do not say which two columns you are wanting to compare or which third column is involved.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
see attached
fuel consumption.xlsx
Click on the star if you think I helped you
use this formula in cell G4 of the worksheet:
and then drag down and across to populate the table.Formula:
=SUMPRODUCT(--($A$5:$A$19=G$3)*--($B$5:$B$19=$E5)*--($C$5:$C$19))
Thank you very much for helping
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks