[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 440
  • Last Modified:

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
0
BLarry9
Asked:
BLarry9
1 Solution
 
sentnerCommented:
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

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now