Hello everyone,
I need help finding the location of rows from 2 different criteria that are in 2 different columns. and here is an example of the data that I have which is located in sheet1
<tbody>
</tbody>
Example of the results I want to show are as follows :
If the value in cell D2 = ec and cell D3 = v7
then the message box will display the row location (5)
Any help is appreciated. Thanks!
Kayza
I need help finding the location of rows from 2 different criteria that are in 2 different columns. and here is an example of the data that I have which is located in sheet1
A | B | C | D | |
1 | Data-1 | Data-2 | FIND : | |
2 | ec | x | ec | |
3 | ec | z1 | v7 | |
4 | dh | r | ||
5 | ec | v7 | ||
6 | dh | kr | ||
7 | sp | ro | ||
8 | ... | ... |
<tbody>
</tbody>
Example of the results I want to show are as follows :
If the value in cell D2 = ec and cell D3 = v7
then the message box will display the row location (5)
Any help is appreciated. Thanks!
Kayza
Last edited: