Need help with lookup formula

		Microsoft Office Forums > Microsoft Excel > Excel
Need help with lookup formula

FAQ

Thread Tools

Display Modes

08-14-2017, 07:16 AM

NBVC

Windows 10 Need help with lookup formula

Office 2013

The Formula Guy

Join Date: Mar 2012

Location: Mississauga, CANADA

Posts: 215

Hi,

In G3, try:

=$A3-IFERROR(INDEX($A4:$A$12,SUMPRODUCT(($B4:$F$12=B3)* (ROW($B4:$F$12)-ROW($B4)+1))),0)

copied down and across.

If there is no match and you want blanks instead of the large numbers, then use

=IFERROR($A3-INDEX($A4:$A$12,SUMPRODUCT(($B4:$F$12=B3)*(ROW($B4 :$F$12)-ROW($B4)+1))),"")

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula help please (lookup across multiple sheets)	froggybsb03	Excel	2	03-16-2017 02:16 AM
"lookup" formula	MrT2016	Excel	2	12-20-2016 07:40 PM
LOOKUP - Complex lookup with 2 lookups in 1 cell	sglandon	Excel	6	05-05-2016 09:44 AM
Lookup	Tony Singh	Excel	3	03-06-2015 11:03 AM
Lookup	angie.chang	Excel	1	07-27-2012 09:45 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:03 AM.