M
mark.wolven
I have an array of cells, B3:J34 on sheet2.
On sheet, 1, column, I have a range of values that can be found in the
array on sheet2. I'd like to put a function on column b, sheet1 to
return the value in row 2, above the searched value from sheet1 ,
column A. Does that make sense?
Basically, I want to search for a value within an array, and return
the value in row 2 when the searched value is located.
Thanks
On sheet, 1, column, I have a range of values that can be found in the
array on sheet2. I'd like to put a function on column b, sheet1 to
return the value in row 2, above the searched value from sheet1 ,
column A. Does that make sense?
Basically, I want to search for a value within an array, and return
the value in row 2 when the searched value is located.
Thanks