excel scrpiting

Hi, i have an excel question to ask, might need scripting, not sure yet.

in same excel 2010 file.
sheet1 has name and installed as two columns
sheet2 has computername as a column

there are about 600 records in sheet1
there are about 300 records in sheet2

if a record in sheet1 matches any records in sheet2, then i would like to input a Yes as text in sheet1 installed column.

does any one know how to deal this faster?

thanks a lot.

S
BLarry9Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
sentnerConnect With a Mentor Commented:
Sounds like a simple VLOOKUP command.  

In Sheet one, on the first cell for installed (I'll assume B2 and assume that sheet 2 computername is in column A), put:  

=IF(ISERROR(VLOOKUP(A2,Sheet2!A:A,1,FALSE)),"No","Yes")

Then, copy that formula down to the other rows in that column.
0
 
BLarry9Author Commented:
thanks a lot.

works great!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.