dankot123
01-15-2017, 04:44 PM
im trying to write some vba code for an excel function where the purpose is to
look up three parameters on a three column table and to return the row number where all three parameters match.
for example the table looks like this
a 1 one
b 1 one
a 1 two
b 1 two
a 1 three
my paramters are -> b 1 two,
therefore the answer should be row 4
does anyone know of any function that already does this or of a way to do it, I'm pretty new to the language and have had a lot of trouble with it
look up three parameters on a three column table and to return the row number where all three parameters match.
for example the table looks like this
a 1 one
b 1 one
a 1 two
b 1 two
a 1 three
my paramters are -> b 1 two,
therefore the answer should be row 4
does anyone know of any function that already does this or of a way to do it, I'm pretty new to the language and have had a lot of trouble with it