Hi all, please forgive my utter newbieness to the world of Excel. I'm in need of some serious help and I'm hoping someone here is kind enough to save the day.
I have a table right now relating to keys (physical ones). They're numbered 1-100 and I have a column in my table called "Sets" that I'm currently just typing in to acknowledge which keyset that specific key appears in - sometimes none, sometimes many.
I had a thought and have set up a second sheet on which I have the name of the keyset (for example, Alice's Personal) followed by cells containing the key numbers on that set. What I'd like to do is find a way to have the keyset column check if the number of the key (in column A of sheet1) appears anywhere within a range on the second sheet (so for example lets say "Alice's Personal" is written in A1 and B2 to F6 have the numbers 1 to 5 in them), and if it does then the value in A1 ("Alice Personal") appears in the specific cell in the keyset column.
I'm really struggling to think of how to do this. Originally I tried to use IF, so like =IF(Sheet2!B2:F6=A1:A101,"Alice's Personal","")
But I keep getting a value error. Not even sure IF can be used like that.
Basically: please help me I beg of you.
Bookmarks