Wednesday, August 8, 2012

yogi_Return Value From A Column Based Off Three Matching Cells In Two Different Sets Of Columns

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #680   Aug 08, 2012

user PBD Records said: (!category-topic/docs/spreadsheets/TM3e43o5LmE%5B1-25%5D)
Got another question for you guys with regarding the same spreadsheet as before, it is now open to the public so you can see what i'm referencing. 
I have a feeling Vlookup is what I need to use but I can't figure out how to do it with multiple values. Basically what I need is to return the info from column N, to column J if the corresponding cells D,E,F are the same as cells K,L,M.
So for example on J1 I would want the value "Shipping Cost" from N1 returned by finding the matching combination of D1,E1,F1 from columns K,L,M and returning the corresponding input from column N

Btw I am referring to the page "Amazon Importer". Thanks in advanced for the help!
following is a solution to the problem

No comments:

Post a Comment