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

		Microsoft Office Forums > Microsoft Excel > Excel
If (cell) is (range of cells), then (cell) should be (range of cells)

FAQ

Mark Forums Read

Thread Tools

Display Modes

11-07-2016, 07:12 PM

ExcelPatient ExcelPatient is offline

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

Mac OS X

Office 2008 for Mac

Novice

Join Date: Nov 2016

Posts: 3

New wrinkle

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

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:25 AM.