Filling a formula down a column where only one cell value referenced changes?

		Microsoft Office Forums > Microsoft Excel > Excel
Filling a formula down a column where only one cell value referenced changes?

08-27-2018, 03:23 AM

xor

Windows 10 Filling a formula down a column where only one cell value referenced changes?

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,101

What about

=IF(AK3=Sheet2!$A$1, Sheet2!$B$1,IF(AK3=Sheet2!$A$2,Sheet '2'!$B$2,IF(AK3=Sheet2!$A$3,Sheet2!$B$3,"")))

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Filling a formula down a column where only one cell value referenced changes?	takamaz	Excel	2	03-11-2018 08:56 AM
formula help - value in cell looking up row and column using great than less than	stefano	Excel	3	10-20-2017 02:20 PM
Entering a column value in a cell, to be used as part of a reference in a formula in another cell	paulkaye	Excel	4	02-26-2017 04:18 AM
What formula can I use to find the lowest cell in a column that has a value in it?	EddyWD	Excel	3	04-20-2016 09:29 PM
column of data referenced to multiple grids on another sheet	zorniac	Excel	1	11-15-2013 10:19 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:55 PM.