Yogi Anand, D.Eng, P.E. Google Spreadsheet Post #680 Aug 08, 2012 www.energyefficientbuild.com.
user PBD Records said: (http://productforums.google.com/forum/?zx=mbrto4iboxtd#!category-topic/docs/spreadsheets/TM3e43o5LmE%5B1-25%5D)
https://docs.google.com/
spreadsheet/ccc?key=user PBD Records said: (http://productforums.google.com/forum/?zx=mbrto4iboxtd#!category-topic/docs/spreadsheets/TM3e43o5LmE%5B1-25%5D)
https://docs.google.com/
0AmLJ51Du91u7dE4wOEM1WU1xWWNyc
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