Get instant live Excel expert help with MATCH Functions

I have two sheets in a workbook. The first sheet has formulas to determine a set price. The second sheet has a column that uses vlookup to display the price from the formula. I have another column on that same sheet with old prices. I want to use conditional formatting to highlight prices that are different, but it seems to highlight everything based off of the formula, even if the prices are the same. How can I get it to compare the values from the formula?

I want to compare a ref in column A to see if it is anywhere in Column G, and put the answer yes or no in another column ; what formula should I use

Compare column A to I in different worksheets and if matches, extract data from b to az

i am trying to look up a unique id to compare to a another list

22. Narlen wishes to compare the use of the money for this project to simply investing the money at the prevailing interest rates. They want to know what interest rate would be required that would provide a better return on the money by investing versus doing this project. Enter the values 1% through 15% in D23:R23 to represent possible interest rates. Calculate Net Present Value in D24:R24 using the NPV function for each of those rates for Years 1-15 plus Project End, adding the initial Startup profit value in C21 to the result of the NPV in each cell.

I want to know that what to use in excel if I want to compare 6 value in a column, with the condition as follows: 1-A 2-B 3-C 4-D 5-E 6-F where 1,2,3,4,5,6 are values of the column; then if 1 is generated A should be printed and so on. but if 1-6 are generated then A,B,C,D,E,F should be printed

22. Narlen wishes to compare the use of the money for this project to simply investing the money at the prevailing interest rates. They want to know what interest rate would be required that would provide a better return on the money by investing versus doing this project. Enter the values 1% through 15% in D23:R23 to represent possible interest rates. Calculate Net Present Value in D24:R24 using the NPV function for each of those rates for Years 1-15 plus Project End, adding the initial Startup profit value in C21 to the result of the NPV in each cell.

wanting to update the formula on this file to compare a list of names

first file contains mess attendance daily basis in numbers 1,2,3---- Other file contains members detail, rates which is updated daily basis according to attendance... in order to put attendance in 2nd file, i want automatically excel compare and mark attendance.. plz help.. how to filter second file serial number with respect to first file ID column

compare the z scores fo rthe following raw scores where x=50 and the standard deviation =-5.