VLOOKUP and TEXT if data is present

[rayted]

Hi guys,

I have a master list of employees and I would like to see if they worked in specific quarters on a project.

Can someone help me with what I think should be a VLOOKUp formula?

Column A is my master list.

Column B has the employee codes which i am trying to lookup against Column A. Also, if the employees are returned as being present in Column A, I would like it to say 'YES' and 'N0' if they are not in the list.

Can anyone pls help?

thanks!

The file won't let me upload for some reason.

[Pete_UK]

It is difficult to advise with such sketchy details, as you make reference to where the quarters data is located. Try to upload the file again:

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post. Don't try to use the Paperclip icon (Attachments button), as it doesn't work on this forum.

Pete

[rayted]

Hi pete,

I have uploaded an image - sorry my sentence about quarters was more of a contextual thing.

Anyway Columns A, B, C and D are visible in the screenshot.

Thank you!

[Glenn Kennedy]

Will you please attach a SMALL sample Excel workbook (10-20 rows of data is usually enough)? Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).

1. Make sure that your sample data are truly REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired solution is also shown (mock up the results manually).

3. Make sure that all confidential information is removed first!!

4. Try to avoid using merged cells. They cause lots of problems!

Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

[rayted]

Hi

I have reduced some text and saved it as a new workbook and that has uploaded

I kept getting error messages below (saying file upload failed).

Thank you!

[AliGW]

Try this:

=IFNA(IF(VLOOKUP(D2,$B$2:$B$19,1,0)>0,"Yes"),"No")

or this:

=IF(COUNTIF($B$2:$B$19,D2)>0,"Yes","No")

Lots of ways to skin this particular cat.

[Kaper]

Assuming original explanation about master column A, use:

Please Login or Register  to view this content.

and copy it down, as well to other columns.
of course you can use it in conditional formatting rule, or nest it within IF, like:

Please Login or Register  to view this content.

[rayted]

Try this:

=IFNA(IF(VLOOKUP(D2,$B$2:$B$19,1,0)>0,"Yes"),"No")

or this:

=IF(COUNTIF($B$2:$B$19,D2)>0,"Yes","No")

Lots of ways to skin this particular cat.

Thanks Ali! Nice quote lol

[AliGW]

No problem.