vlookup or something else ?

**gtdw** · 04-19-2015, 08:44 AM

I was wondering. Is there easy way to make in vba new function like vlookup in table2 which finds values from table1 but for each double like "1" in example below result of looking will be next value from table. Also If "1" appear more times in table2 than table1 results will be string "new"

sampl.jpg

**MarvinP** · 04-19-2015, 09:49 AM

Hi gtdw and welcome to the forum,

This takes an Index Match type of formula and also needs a CSE (Control + Shift + Enter) keystroke to confirm the array formula.
See: http://www.cpearson.com/excel/ArrayFormulas.aspx or http://www.databison.com/excel-array...ray-constants/

**gtdw** · 04-19-2015, 10:11 AM

thanks for example, I will learn more about index function.

**nilem** · 04-19-2015, 10:24 AM

or maybe so

Please Login or Register  to view this content.

**gtdw** · 04-19-2015, 02:37 PM

works also well but for me as beginner in VBA is way more difficult to understand

Again thanks a lot.

**gtdw** · 04-20-2015, 02:56 PM

Can you help me with another issue ? Let's suppose in new table 2 there is another column with fixed value. For double number like "1" if results of searching from table 1 is equal to one of constant value from new column then switch this both results to have to get one pair. I know its sounds complicated but maybe someone will understand

sample2.png