Saturday, August 31, 2013

yogi_Pull Into yogi_Result Corresponding Values For URL Visits And Sell Numbers

                                          Google Spreadsheet   Post  #1351
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Aug 31, 2013
user Ramarosoa Faneva (http://productforums.google.com/forum/?zx=1nlqkgk0rsyr#!category-topic/docs/spreadsheets/5GoLpHpfODM)
Vlookup content
Hi All,

I m searching a solution to use the vlookup in cells content. Below you have an example.

Ex : 
Sheet 1 content : URL + Visitors
Sheet 2 content : SKU + Sales

Specific : the URL contains the SKU and she is uniform.

My purpose : search if the URL contains the SKU, give me the URL and the visitors.

I other program I can use vlookup("*"&C1&"*"........) but i don't know how to do it in the google spreadsheet.

Ty for your help
---
Hi Yogi,

There is the link for an example : Link

The purpose is to complet the sheet "result" just by dragging the formula.

(I don't know realy well how can i explain it to you but look the file and you understand automaticly the purpose of the my question).

Ty for your help.
-------------------------------------------------------------------------------------------------------------------------------------------------------