Hello.
I have been trying to figure this out, but I have failed.
I have two ranges, A6:A29 and C5:C29.
In a group of cells that are not adjacent, if a number is entered in any of those cells, I would like to compare that number with the list of numbers I have in the two ranges.
If a match is found a popup box will appear with some text.
I have looked at VLOOKUP and MATCH, but I do not understand how to use the functions.
It is probably quite simple, but I cannot figure it out.
Thank you in advance.
I have been trying to figure this out, but I have failed.
I have two ranges, A6:A29 and C5:C29.
In a group of cells that are not adjacent, if a number is entered in any of those cells, I would like to compare that number with the list of numbers I have in the two ranges.
If a match is found a popup box will appear with some text.
I have looked at VLOOKUP and MATCH, but I do not understand how to use the functions.
It is probably quite simple, but I cannot figure it out.
Thank you in advance.