I'm trying to create a formula to lookup the master sheet, find all
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 FILE

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 LOCATION

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 THE
VALUE IN COL B = THE LOCATION.

Therefo

*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...


--
jarviscars
------------------------------------------------------------------------
jarviscars's Profile: http://www.excelforum.com/member.php...o&userid=25631
View this thread: http://www.excelforum.com/showthread...hreadid=390438