I need the exact row number dynamic values (based on user input) might potentially exist in a macro. For example, if cell J2, K2, L2 values match table defined values in columns A, C and F (i.e., J2 has abc, K2 has 123, and L2 has xyz ...and it is only considered a match if those values all work in tandem in any row for columns A/C/F ). I can do this with an Index/IF function but I need the ability to throw a validation message to the user advising of the row number the user defined values exist in. Is there a way? Also if no match exists, then I need a validation message citing that Nothing exists.
Last edited: