Check table for value in TextBox and return value from same row in table

[K1600]

I'm sure this is quite simple and I am rather annoyed with myself that I can't get it to work but, I can't!

I have a table (Table9) in sheet (Trained Staff) which is formatted as an excel table with headers. The relevant of those headers for this bit being "Issuer" and "Authority status".

I also have a UserForm (UFAddEntry) with a text box (TxtIssuer) and I just want to look through the data in Table9 for the value in the textbox (in the Issuer column) and if the value in the 'Authority status' column is anything other than "Active" then to give me a messagebox with what the 'Authority status' value is.

Can anyone assist please. Thanks in advance.

 

[K1600]

Ok:

Works spot on! Thanks again for your help.

G

 

[My Aswer Is This]

Works spot on! Thanks again for your help.

G

And my new script does not use Offset. I figured out the better way. So no matter where the column is in the table
I always learn more myself as I help others
Glad I was able to help you.
Come back here to Mr. Excel next time you need additional assistance.