Dave T
08-23-2013, 06:48 AM
Hello All,
I have a workbook with a list of structures on a worksheet call ‘BIS’ and on another worksheet called ‘Element material types’ is a list of their elements.
I suspect that trying to use VLOOKUP is the wrong formula and I should probably be using INDEX and MATCH, but I am not that familiar with this.
What I have been trying to do is create a LOOKUP formula in column B in the ‘BIS’ worksheet that will do a LOOKUP within the ‘Element material types’ worksheet and find the same ‘Plan No.’ and within the ELEMENT TYPES DESCRIPTION column if it is a ‘Deck’ it will return ‘slab’ from the SUB ELEMENT TYPES DESCRIPTION column.
A LOOKUP formula in column C in the ‘BIS’ worksheet that will do a LOOKUP within the ‘Element material types’ worksheet and find the same ‘Plan No.’ and within the ELEMENT TYPES DESCRIPTION column if it is a ‘Deck’ it will return ‘Concrete’ from the MATERIALS TYPES DESCRIPTION column.
A LOOKUP formula in column D in the ‘BIS’ worksheet that will do a LOOKUP within the ‘Element material types’ worksheet and find the same ‘Plan No.’ and within the ELEMENT TYPES DESCRIPTION column if it is a ‘Girder’ it will return ‘Beam’ from the SUB ELEMENT TYPES DESCRIPTION column.
A LOOKUP formula in column E in the ‘BIS’ worksheet that will do a LOOKUP within the ‘Element material types’ worksheet and find the same ‘Plan No.’ and within the ELEMENT TYPES DESCRIPTION column if it is a ‘Girder’ it will return ‘Steel’ from the MATERIALS TYPES DESCRIPTION column.
Within the attached workbook I have just typed in the expected formula results, but I have yet to work out the formulas to do this lookup.
Regards,
Dave T
I have a workbook with a list of structures on a worksheet call ‘BIS’ and on another worksheet called ‘Element material types’ is a list of their elements.
I suspect that trying to use VLOOKUP is the wrong formula and I should probably be using INDEX and MATCH, but I am not that familiar with this.
What I have been trying to do is create a LOOKUP formula in column B in the ‘BIS’ worksheet that will do a LOOKUP within the ‘Element material types’ worksheet and find the same ‘Plan No.’ and within the ELEMENT TYPES DESCRIPTION column if it is a ‘Deck’ it will return ‘slab’ from the SUB ELEMENT TYPES DESCRIPTION column.
A LOOKUP formula in column C in the ‘BIS’ worksheet that will do a LOOKUP within the ‘Element material types’ worksheet and find the same ‘Plan No.’ and within the ELEMENT TYPES DESCRIPTION column if it is a ‘Deck’ it will return ‘Concrete’ from the MATERIALS TYPES DESCRIPTION column.
A LOOKUP formula in column D in the ‘BIS’ worksheet that will do a LOOKUP within the ‘Element material types’ worksheet and find the same ‘Plan No.’ and within the ELEMENT TYPES DESCRIPTION column if it is a ‘Girder’ it will return ‘Beam’ from the SUB ELEMENT TYPES DESCRIPTION column.
A LOOKUP formula in column E in the ‘BIS’ worksheet that will do a LOOKUP within the ‘Element material types’ worksheet and find the same ‘Plan No.’ and within the ELEMENT TYPES DESCRIPTION column if it is a ‘Girder’ it will return ‘Steel’ from the MATERIALS TYPES DESCRIPTION column.
Within the attached workbook I have just typed in the expected formula results, but I have yet to work out the formulas to do this lookup.
Regards,
Dave T