Dificulties to manage VLOOKUP

[felisberto queiros]

Good afternoon Gents

On the moment I’m working in a file and I’m struggling to manage VLOOKUP.
I’ve tried many times but the result is always #N/A.
Basically the file has three sheets:
- Operation list – is the data base sheet
- Piping System – the report that I want to fill with the data extracted from data base
- Cooling System – the report that I want to fill with the data extracted from data base

The “Piping System sheet” should:
- only show the data in which the lookup value [PIPING SYSTEM Module-1] on the data base sheet appears on columns N, O and P.
- has all info from column B to column M,

Please consider the attached file.

Can you please help me to figure out how can I fill each one of those reports with the right info?

My regards

 

[mole999]

You can't attach files here, you need to post it to a cloud where it dosen't need a user to create an account to download it, and post the link back to this thread

 

[Fluff]

Cross posted Dificulties to manage VLOOKUP

While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[felisberto queiros]

Cross posted Dificulties to manage VLOOKUP

While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

Good morning

Yes, you are right.
I will not do it again.

The link that I've missed to post is

Dificulties to manage VLOOKUP [SOLVED]

Good afternoon Gents On the moment Im working in a file and Im struggling to manage VLOOKUP. Ive tried many times but the result is always #N/A. Basically the file has three sheets: - Operation list is the data base sheet - Piping System the report that I want to fill with the data...

www.excelforum.com