How do I get column E to skip rows where there no duplicate in column A.
Add a comment
|
1 Answer
Instead of trying to figure out how to insert blank rows in Column E and F where there is a missing value based on A... use a Vlookup() in Column D to grab the relevant pieces from Column F:
Assuming your data starts on A16 according to your picture, in D16 enter:
=Vlookup(A16, E:F, 2, False)
And copy that down. Now you will have Column F values in their appropriate rows in Column D.
-
I uploaded the original spreadsheet, I need to add the values in column H to column I, but I need to match up the cells based on columns A and G.– S.ACommented Mar 17, 2016 at 20:42
-
So, in a new column you could do
=Vlookup(A267, G:H, 2, FALSE) + Vlookup(A267, G:I, 3, FALSE)That will look up the value inA267into ColumnG, when it finds it's match, it will first grab the value in ColumnH(the second column of RangeG:H) and then it will add to that the found value in ColumnI(the third column in RangeG:I).Vlookupis your friend for this type of situation where you have to find values in one list, inside another, and then return corresponding values in other columns.– JNevillCommented Mar 17, 2016 at 20:46 -
-
It will do that if the value in
Ais not found inG. You can wrap yourVlookupin aniferror()formula:=IFERROR(Vlookup(A267, G:H, 2, FALSE), 0) + IFERROR(Vlookup(A267, G:I, 3, FALSE), 0)That will set the result of the lookup to0in the event that you get a#N/Areturn fromVLOOKUP()– JNevillCommented Mar 17, 2016 at 20:56
