Good morning,
I am looking for a formula that will look at the values in one column of a sheet, and if those values are less than a reference cell, return the item identifier from another column, into sheet 2. In the attached on sheet 2, I need to pull the item identifier from column B in sheet 1, where the values in column F of sheet 1 are less that cell N2 of sheet 1. Perhaps I need more coffee but I've been playing with if, index, and lookup statements but can't seem to get it to work. Thanks in advance!
Bookmarks