what I have is a VERY large members data base on one sheet.. on another sheet(or sign in sheet) I use the Vlookup to pull data from the members list via scan-able cards (like the ones you see at supermarket key chains) when data is populated in the cells (on the sign in sheet), sometimes a msg pops up in the H column saying "see not on MM list"
what normally happens is my staff has to go to the members data base find the member (or members number) and find the note..
what i would like to happen is when the "see note on MM list" appears, a Message Box pops up and delivers the data from the note that is on the members data base.
the notes are always on the A,B or C column of the data base. and the "see note on MM list" always is in the H column of the sign in sheet.
is this possible.
thanks in advance
Jason