J
jarviscars
I'm trying to create a formula to lookup the master sheet, find al
occurances of the loaction and return the values in the location sheet
(sample outlined below...)
I HAVE A MASTER SHEET WHICH CONTAINS DATA IMPORTED VIA A CSV FIL
Col A = ID Number
Col B = Location
Col C = Brand
Col D = Model
Row 1 = 10001 || Location A || Brand 1 || Model 1
Row 2 = 10002 || Location A || Brand 2 || Model 4
Row 3 = 10003 || Location B || Brand 4 || Model 8
Row 4 = 10004 || Location C || Brand 2 || Model 2
Row 5 = 10005 || Location B || Brand 3 || Model 7
I THEN HAVE SEPARATE SHEETS FOR EACH LOCATIO
Sheet 1 = Location A
Sheet 2 = Location B
Sheet 3 = Location C
THEN EACH LOCATION SHEET WILL ONLY SHOW THE DATA FOR THE ROWS WHERE TH
VALUE IN COL B = THE LOCATION
Therefore:
*Sheet 1 *
Row 1 = 10001 || Location A || Brand 1 || Model 1
Row 2 = 10002 || Location A || Brand 2 || Model 4
*Sheet 2 *
Row 1 = 10003 || Location B || Brand 4 || Model 8
Row 2 = 10005 || Location B || Brand 3 || Model 7
*Sheet 3 *
Row 1 = 10004 || Location C || Brand 2 || Model 2
Any help is appreciated..
occurances of the loaction and return the values in the location sheet
(sample outlined below...)
I HAVE A MASTER SHEET WHICH CONTAINS DATA IMPORTED VIA A CSV FIL
Col A = ID Number
Col B = Location
Col C = Brand
Col D = Model
Row 1 = 10001 || Location A || Brand 1 || Model 1
Row 2 = 10002 || Location A || Brand 2 || Model 4
Row 3 = 10003 || Location B || Brand 4 || Model 8
Row 4 = 10004 || Location C || Brand 2 || Model 2
Row 5 = 10005 || Location B || Brand 3 || Model 7
I THEN HAVE SEPARATE SHEETS FOR EACH LOCATIO
Sheet 1 = Location A
Sheet 2 = Location B
Sheet 3 = Location C
THEN EACH LOCATION SHEET WILL ONLY SHOW THE DATA FOR THE ROWS WHERE TH
VALUE IN COL B = THE LOCATION
Therefore:
*Sheet 1 *
Row 1 = 10001 || Location A || Brand 1 || Model 1
Row 2 = 10002 || Location A || Brand 2 || Model 4
*Sheet 2 *
Row 1 = 10003 || Location B || Brand 4 || Model 8
Row 2 = 10005 || Location B || Brand 3 || Model 7
*Sheet 3 *
Row 1 = 10004 || Location C || Brand 2 || Model 2
Any help is appreciated..