Search within List and return msgbox

[Alesiuk27]

Hi,

I am dealing with one very simple excel problem which i should be able to solve, but my VBA skills are unused for 18months and rusty! I also have a second related one which is stretching my knowledge!

First one:

I have a very simple data sheet with has around 4000 lines of data but only 3 colums. Each cell is a number only.

I want to set up a simple macro to start with an InputBox (even i can manage that part) where the use inputs a number, and the macro then searches only column A for that number. A positive match i want one Msgbox (Match found), negative match i want a different Msgbox (Match not found).

This should be a simple lookup and msgbox but i cant get the combination of functions right! Any help?

Second one:

Same data sheet, i want an inputbox which asks the user for 2 bits of data (enter data 1, enter data 2). I then want a macro to search for a match for data 1 in column B, and data 2 in Column C. only when BOTH match do i want a Msgbox with "match found" - anything else i want "match not found".

This one i am struggling with! Any help much appreciated!

 

[Jythier]

Ah, good! Glad I could help!