Improve company productivity with a Business Account.Sign Up

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

vlookup needed

folks

on sheet 1 i display hostnames (servers) i colum a

server 1
server 2
server 3

in sheet 2 i have the same host lists in column a but have multiple retention values in columb b

i would like to in sheet 1 state yes or no if i do have retentions assigned to each ie see sample attached

all help will do
0
rutgermons
Asked:
rutgermons
3 Solutions
 
Wayne Taylor (webtubbs)Commented:
Try this formula...

   =IF(VLOOKUP(A2, Sheet2!A:B, 2, FALSE) <> "", "Yes", "No")

...where A2 is the server to lookup and your servers and retentions are in columns A and B on Sheet2.
0
 
Katie PierceCommented:
No sample attached.
0
 
gowflowCommented:
It would help if you attach a file.
gowflow
0
 
Rob HensonFinance AnalystCommented:
In sheet 2 are the servers listed multiple times in column a with a retention against each entry in column b?

If so, in column b of sheet1, you can use a COUNTIF function:

=COUNTIF(Sheet2!$A:$A,$A1)

Copied down the extent of the data on sheet1. This will give a numerical result, if not listed at all in sheet2 the result will be 0.

Thanks
Rob H
0
 
gowflowCommented:
Put  this formula in B2 of Sheet1 and expand down as much as you need.
=IFERROR(IF(VLOOKUP(A2,Sheet2!A:B,2,FALSE)="","No","Yes"),"")

VLOOKUP may return #NA if Server name not found in Sheet2 which is handled by the IFERROR function that will return a blank.

Pls see attached workbook.
gowflow
Server.xlsx
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.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering 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