J
Jason Lepack
I'm trying to create something like a cross-table, I need a lookup
function for the grid.
I have a list of data pairings on a worksheet ("FILTERED DATA")
ASSY is in column D
SKU is in Column H
(each of these pairs will be unique)
I have a grid on a worksheet ("MEDIA GRID")
Column D is ASSY
Row 2 is SKU
Row 1 is the qty of each sku required (this data is a vlookup from
another worksheet)
For each space in the grid I want to check to see if there is an
instance of the pair in "FILTERED DATA". If there is then I want the
space to return the value in row 1 of MEDIA GRID. There are going to
be about 45000 grid spaces.
Thanks,
Jason Lepack
function for the grid.
I have a list of data pairings on a worksheet ("FILTERED DATA")
ASSY is in column D
SKU is in Column H
(each of these pairs will be unique)
I have a grid on a worksheet ("MEDIA GRID")
Column D is ASSY
Row 2 is SKU
Row 1 is the qty of each sku required (this data is a vlookup from
another worksheet)
For each space in the grid I want to check to see if there is an
instance of the pair in "FILTERED DATA". If there is then I want the
space to return the value in row 1 of MEDIA GRID. There are going to
be about 45000 grid spaces.
Thanks,
Jason Lepack