Hello There,
Here is what I'm trying to do. I have 2 sheets where on sheet 2 I need a list derived from contents in sheet one based on criteria. I cannot use the vlookup as the information isn't laid out in a format that will work, left to right not right to left. I am going to try and create a UDF for this but I have not been successful referencing ranges on different sheets.
This is what I need to happen
on sheet 2 the formula will need to have 2 different criterias, 1 being department and the other being item number, if those match then return the value of the cell in column A for the matched references
Is there an easy way of doing this. Since these contents change all of the time the list on sheet 2 will always be up todate with the latest information.
Thanks
residnt
Here is what I'm trying to do. I have 2 sheets where on sheet 2 I need a list derived from contents in sheet one based on criteria. I cannot use the vlookup as the information isn't laid out in a format that will work, left to right not right to left. I am going to try and create a UDF for this but I have not been successful referencing ranges on different sheets.
This is what I need to happen
on sheet 2 the formula will need to have 2 different criterias, 1 being department and the other being item number, if those match then return the value of the cell in column A for the matched references
Is there an easy way of doing this. Since these contents change all of the time the list on sheet 2 will always be up todate with the latest information.
Thanks
residnt