I would like to know if there is a way for me to look for 2 separate values in one worksheet and then return a result from an entirely different worksheet? For instance I need to look for B1 & B15 in my main worksheet.......and in another worksheet find these same 2 values but return a different result from that second worksheet into D16 of my main worksheet. Thanks
MAIN WORKSHEET
B1=Site name
B15=Site Location
D16=Site Type (I do not have Site Type in my main worksheet, this is what I am looking for)
SECONDARY WORKSHEET
COLUMN A-has site names
COLUMN C-has site locations
COLUMN CE-has site type (I need to return this result into D16 in my main worksheet)
MAIN WORKSHEET
B1=Site name
B15=Site Location
D16=Site Type (I do not have Site Type in my main worksheet, this is what I am looking for)
SECONDARY WORKSHEET
COLUMN A-has site names
COLUMN C-has site locations
COLUMN CE-has site type (I need to return this result into D16 in my main worksheet)