Data Sorting

[Jayden]

Hello,

Here is my question I have not been using excel for a few years but I am back and need to have a memory refresh

here is my delema

I have a excel spread sheet with 2 pages and on the first is where i want the data to populated, sheet1 has 2 columns. The first is blank and the second list a username the first is where i want the data i need entered

on the second sheet is a imported txt file broken down into columns and i am only concerned with the first 2

here is how i want it to work

sheet 1

column 1 column 2
??? username
??? username1

Sheet 2

column 1 column 2
testing username
testing username1
under username2

I want the code to look into sheet 2 in column 2 to find the username but if column 1 does not have the word testing then i do not want it to show
and if the word testing is there I will then want the code to display a "Yes"
In column 1 on sheet 1

any help would be great

Thank you

 

[Jayden]

sorry close but not really. it needs to find both if the word testing and the username are there then put yes but if there is a down directly below the username then put a blank

it has 2 things that it needs to check for first if there is a "testing" to the left and then for a "down" below

if there is both a testing and a down then there should be a blank displayed
but if there is just a "testing" then it should have a yes displayed

 

[Jonmo1]

That's exactly what my last post does.

 

[Jayden]

thank you