I have two sheets. Both are ordered using different criteria, however I would like to link the records of one sheet to one of the fields in the second.
My thought was to use the match formula to pull the record number of one and then use that found number in an if statement on the other sheet.
e.g. =if(sheet1!A<supplied number from the match results>= "cookie", "eat, "don't eat")
Each line would evaluate the column and the variable from the match results.
I haven't figured out how to write this...is it even possible?
Is there a better way?
Thank you in advance!
signed,
humbled
Bookmarks