Hello everyone,
I am in sheet 2 A2.
I would like to search a row (10) from sheet 1 to match sheet 2 A1.
If i have a match,
I would like to search the row below (11) from the reference cell (i.e. AG10) for the next column encountered that contains a 5.
When i encounter a 5 in the column i would like to return the value from a particular row (column match row 449)
Thanks in advance guys!
I am in sheet 2 A2.
I would like to search a row (10) from sheet 1 to match sheet 2 A1.
If i have a match,
I would like to search the row below (11) from the reference cell (i.e. AG10) for the next column encountered that contains a 5.
When i encounter a 5 in the column i would like to return the value from a particular row (column match row 449)
Thanks in advance guys!