Trying to type in sheet1 that will search sheet 2 and return answer from sheet 2 to sheet1

I hope that I can explain this problem correctly. What I am trying to do is type a specific computer model in sheet1. The in turn. Will start a search in sheet2 that has all the models in column A. This will copy the Yes/No answer from sheet2 column B to the correct column in sheet1. Very new to VB coding and macros. Im thinking I need a loop that will do a search and copy. Than a secondary set of code to past. Every time I try something. I FUBAR my excel sheets. Can do formulas decently. But I dont think a formula is the way to go. Thank you for your help.

Sheet1
Column B
Model (lable of column B)
HP T610 (Thin Endpoint)
HP DC 5100
MAC G3 (example computer)

Column D
Win 7 Compatible?(Lable of column C)
Yes
No
? (Need to populate this column with Yes/No from sheet2)

Sheet2
Column A
Model
HP T610 (Thin Endpoint)
HP DC 5100
MAC G3 (Need to search and find this model from sheet1)

Column B
Win 7 Compatible?
Yes
No
No (Need this to transfer to Sheet1 column D)

Where you are new to macros but "decent" at formulas, is there a specific reason to do this in VBA? It seems to me that, for someone who is decent with formulas, this should be a relatively simple VLOOKUP() function or other lookup function.

I do mostly math formulas not so much a search and copy from one sheet to another. The reason for a macro. Is that going threw allot of the forums here. It appears as the best method for this issue. Since the list will be changing and being added to. But no matter what I try. I just cant get it down. I mostly deal with hardware. So adding how many video cards to desktops(Example) is what I mainly do with excel. This is a new task for me and I am completely lost. Thank you for replying.

I have been bouncing from excelforum.com, microsofts website and another website (not sure if I should say the name.) Trying to learn this. Not as easy as I thought.

I do mostly math formulas not so much a search and copy from one sheet to another.

You are like me in this respect -- learned how to do math in a spreadsheet before you learned how to do lookups.

Without more detail, I'm not convinced that a macro is the best method. I would suggest you start with the VLOOKUP() function (http://office.microsoft.com/en-us/ex...011.aspx?CTT=1) =VLOOKUP(B2,sheet2!$A$2:$B$2000,2,false) where B2 contains the lookup value. For a variable size database, I will usually just set the lookup_table argument to be larger than the largest data set I expect to see.

Unless there is more to this, this seems to me that this should do the job.

On edit: If you have cross - posted this somewhere, we would like to know where (see form rules about cross-posting). That way, if you find your solution elsewhere, we can know that and stop trying to find a solution to a problem someone else has helped you solve.

If you really want to do this in VBA, you might consider looking at the FIND method (http://msdn.microsoft.com/en-us/libr...ice.15%29.aspx) and/or how to use Excel's lookup functions in VBA (http://msdn.microsoft.com/en-us/libr...ice.11%29.aspx).