I am trying to come up with a formula that does this.

If A7 on worksheet '05-29' is equal to any of the cells in column A on worksheet 'notes' then give me the data in Column B on that same row.

I assumed a basic IF formual like this =IF(A7=Notes!A1,Notes!B1,"") would work but it relies on the cells being in order everytime. In one week account ID 239 might not buy anything from us so I won't need his notes.

I have wasted a lot of time doing this manually so I would be thrilled if someone could help.

Thanks!
Luke