Please help macro genius: match 2 vals & return 3rd!

**PixelNation** · 09-24-2009, 02:59 AM

Hi there!

I'm trying to write a macro that will ask a user to input two values and search for a match for the first value in column A and the second value in column b (values must be in the same row).

If a match in both columns is found then I would like the macro to return the cell value of column c in the same row (eg msgbox "Match found: column c value")

If the search can only find 1 of the 2 values in the same row or there are no matches then I would like the macro to say something like "No Match Found".

Your help would be very, veery much appreciated!!!!!

Thanks in advance - Pixelnation

**DonkeyOte** · 09-24-2009, 03:06 AM

Welcome to the Board, however, I'm afraid...

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.