Hello,
I'm trying to find a function or vba code that will help me find a certain string of numbers in a full table of numbers.
Example: I want to be able to have 4 cells in a row like below.
5 5 10 15
and I want to be able to find the 4 cells in that row above that are in the table below that will return the first number.
#1 3 3 9 16 #2 5 5 10 15 #3 5 6 7 8 #4 5 10 15 20
I want to be able to find the cells 5 5 10 15 in the table and bring back "#2" in another cell.
I'm not sure if writing a VBA code would be easier or if there is a function that I could use to find the information.
Thank you
Bookmarks