I inserted this formula; but it results in a #VALUE result.
I basically need to do the following -
look up data in sheet 1 cell A1 to Sheet 2 relating to data in column A. The argument being that if what is A1 sheet 1 and sheet 2 column A to return the value that is in Cell J50 if it relates to a specific code in Column B1 in sheet 1 and the same code in Column C in sheet 2
@Margs2025 The first argument must be just the column with the values for the criteria. Also, the size of the range (# of rows) should be the same. Furthermore, you have omitted an argument (the criteria belonging to column C). Finally, you want to set the references to absolute.