Define and use names in formulas
temp_rng is a list (named range) of your:
com.
org.
WWW.
www.
aNDROID
.org
.........
etc.
this is what you are looking for in first part of formula. You are looking "com." in A2 but...
the second part (with VLOOKUP) looking value of A2 in another sheet in B:C and return value from C
this is two different values to lookup and two different results.
or I don't understand 
maybe you want:
edit:
1. you need to create list of your all find_text parameters
2. if you want use range you should use: e.g. Sheet6!$A$1:$A$2 not only Sheet6!A1:A2
3. read more about named range you can define named range in Google sheet also
- Open a spreadsheet in Google Sheets.
- Select the cells you want to name.
- Click Data > Named ranges. A menu will open on the right.
- Type the range name you want.
- To change the range, click Spreadsheet Grid.
- Select a range in the spreadsheet or type the new range into the text box, then click Ok.
- Click Done.
Range names:- Can contain only letters, numbers, and underscores.
- Can't start with a number, or the words "true" or "false."
- Can't contain any spaces or punctuation.
- Must be 1–250 characters.
- Can't be in either A1 or R1C1 syntax. For example, you might get an error if you give your range a name like "A1:B2" or "R1C1:R2C2."
etc.... etc...
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks