If (cell) is (range of cells), then (cell) should be (range of cells)

ExcelPatient · #3 11-07-2016, 07:12 PM

Awesome. Very helpful.

Now, a new issue.

(Q5) is reading an error because (Q4) is a formula that calculates the average of (Q1-Q3) and its result contains a number to the millionth, which the VLookup in (Q5) cannot find. Obviously, I cannot include all possible divisions between 1 and 5 inside (A8:B21).

(Q4) formula reads: =IF(COUNT(Q1:Q3)>0,AVERAGE(Q1:Q3),"")

See picture, below.

Screen Shot 2016-11-07 at 8.01.33 PM.png

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
If value of cell A Matches a value in a Range of cells (column) then add value of cell A to cell C	rick10r	Excel	1	07-05-2016 12:07 PM
Search Range Within Cell or Cells	COEngineer	Excel	1	06-01-2016 11:50 AM
Copying text range of cells to different cells adds an extra line	jpb103	Word VBA	2	07-23-2014 12:22 PM
Count range cells eliminating merge cells	danbenedek	Excel	0	06-15-2010 12:40 AM
Moving formula range multiple cells when moving sum over one cell	FraserKitchell	Excel	4	02-26-2010 10:38 AM