Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 437
  • 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

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

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