Hi,
2 questions for you today.
Is it possible to compare 2 columns when using vlookup or something similar? For example, the spreadsheet I'm dealing with has 2 columns and I need to pull data from another worksheet into a third column.
Column 1 has company names with a lot of duplicates and column 2 has employee names (some duplicate names but not as many). The other worksheet has 3 columns. Columns 1 and 2 are identical to the previous worksheet and column 3 has e-mail addresses.
Is it possible to compare and match the data in column 1 + 2 and, if they match up with columns 1 + 2 in worksheet 2, then pull data contained on the same row but in the third column?
That's the first question!
The second question is this:
How can I write a script that will fill a range of cells with a formula (e.g. vlookup)? I tried to use autofill but it messes up the ranges and increments the lookup_value by 1 (which is what I want) but at the same time increments the table_array values by 1 as well which is not what I want. How can I get around this?
Sorry for all the questions. Hope someone can help me out. :D
James
2 questions for you today.
Is it possible to compare 2 columns when using vlookup or something similar? For example, the spreadsheet I'm dealing with has 2 columns and I need to pull data from another worksheet into a third column.
Column 1 has company names with a lot of duplicates and column 2 has employee names (some duplicate names but not as many). The other worksheet has 3 columns. Columns 1 and 2 are identical to the previous worksheet and column 3 has e-mail addresses.
Is it possible to compare and match the data in column 1 + 2 and, if they match up with columns 1 + 2 in worksheet 2, then pull data contained on the same row but in the third column?
That's the first question!
The second question is this:
How can I write a script that will fill a range of cells with a formula (e.g. vlookup)? I tried to use autofill but it messes up the ranges and increments the lookup_value by 1 (which is what I want) but at the same time increments the table_array values by 1 as well which is not what I want. How can I get around this?
Sorry for all the questions. Hope someone can help me out. :D
James