V-lookup a word in another sheet and return that word

I have two sheets in a workbook, I would like the v-lookup to return sub in Col B if found  or par in Col C if found on the second sheet for the matched number is col A. The problem is when I did the V-loookup it gave me the first occurrence. How do I tell the V-lookup to look for that specefic word per each number in column  A.  

Workbook Sheet 1                              

Col A   Col B          col                                
5879       sub         par
898         sub

Worksheet 2

COL A  COLB
5879     sub
5879     par
5879     cast
898      sub
6778     sub
89566   cast
Danielle JonesAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Haris DulicCommented:
Attached is example how you can do it...
VLOOKUP.xlsx
0
Danielle JonesAuthor Commented:
The two words I am actually searching for is "Tops Obs Scheduled" and "End Stages", The Col thats searching for the first word works, but End Stages is not, it's defaulting to Not. Any ideas?
0
Haris DulicCommented:
I changed the formula according to your values and they are working fine.. .Maybe in the second formula there is space before or after in the part of server value... Since it is working for the first should work for the second..

If there is still an error can you send me sample of your file to check it
VLOOKUP.xlsx
0
Katie PierceCommented:
I would create four columns to the right in the second sheet.  The first would have =IF(E2="","",A2), which would only give you the ID number if there was a value in the next column. The second would have =IF (B2="sub,"sub",""), which would give you a column of subs and blank cells.  Do the same in the next 2 columns with "par", which will give you a column of ID numbers and a column of pars and blanks.

Now do VLOOKUP with those four columns. The first column in sheet 1 will look to the 2 sub columns in sheet 2, and the second to the 2 par columns.

See attached.
Book1-VLOOKUP.xlsx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

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.