Vlookup, Index & Match - Grab values and compare! HELP

Greetings to all.
First of all, I am new to this forum and need the help of your excel knowledge.

I have a workbook with the Sheets: A, B, C. On the B sheet I am collecting data from sheet A, and trying to collect other data from sheet C. Since the VLOOKUP wont collect negative col_index_num, I am trying to find a solution with index and match formula, but can't manage it. I am posting images to give a visual of my problem. If you need other info or more details, please let me know and maybe I can upload the document for you. As you can see on the image number 2 I need to collect data with circle- only the value next to the 'direct:' text.

Thnx in advance.

doc A.png
doc B.1.jpg
doc B.2.jpg
doc C.1.png

Undeclared cross-post : https://www.mrexcel.com/board/thread...-help.1167793/

Welcome to the forum.

Which is it: 2019 or 365? There are significant differences.

There are instructions at the top of the page explaining how to attach your sample workbook.

OK - where you have two versions in your profile, always preface a new query with the one the query pertains to, please, to avoid confusion.

Could you upload the requested workbook?

Welcome (back) to the forum.

Thanks for your question. However, we have just found out that you have posted the same question elsewhere.... and haven't told us. Feel free to cross-post on other sites...

But. Every forum has its rules. Please see Forum Rule #3 about cross-posting. So.

Do not keep it a secret. We all are willing to give you our time, freely. However, some of us get very annoyed if we waste our time developing a solution for you, when you already have a nice solution elsewhere. All we ask is that you show us some respect and tell us:

1) if you have cross-posted, and

2) the URL of the cross posts.

That way, those of us who don't want to waste their time can quickly check to see if you're already happy with another solution.

(Note: since you are a new member, on THIS occasion I have done it for you.)