• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Vlookup

Myer

New Member
I have snookered myself.
I have a database of machine spare parts.
Each machine has an array of part descriptions, part numbers and costs.
I have an entry tab where I enter the machine model number.
I have a grid where I can do a vlookup for parts based on a drop down table.
However....
This works for one machine based on my vlookup formula.

What I am trying to achieve is, if I change the model number in a Cell on a different Tab . I need to change the vlookup to a range for that specific machine.
Eg: Machine T2 is from B2:G23. Column A has the T2 before every row.
Machine T3 is from B25:G47 Column A has the T3 before every row.
=IFERROR(VLOOKUP(G8;Database!$B$2:$E$23;4;FALSE);0)
So Database needs to look in Tab Database, but add the specific array range for that machine.

So far I'm stuck.

Regards Myer
 
You can try with wildcard assuming G8 cell holds values like T2, T3 etc. See if below approach works for you.
=IFERROR(VLOOKUP(G8&"*";Database!$B$2:$E$47;4;FALSE);0)
 
Back
Top