Hello,
I have a row with ten cells populated with names on one worksheet (columns B-K). One a second worksheet I have several hundred names in column A and values next to them in column B.
Is it possible to compare the names in the row against the names on the second worksheet and return the lowest value?
I would like to put a formula next to each row (in column A on the first worksheet) that reads across the row and returns the lowest value.
I have tried several array formulas and have been unable to figure out how to do this.
Thank you in advance for your help!
I have a row with ten cells populated with names on one worksheet (columns B-K). One a second worksheet I have several hundred names in column A and values next to them in column B.
Is it possible to compare the names in the row against the names on the second worksheet and return the lowest value?
I would like to put a formula next to each row (in column A on the first worksheet) that reads across the row and returns the lowest value.
I have tried several array formulas and have been unable to figure out how to do this.
Thank you in advance for your help!