Refer to NamedRange, Col1 in formula to find value?

  • Thread starter Thread starter Ed from AZ
  • Start date Start date
E

Ed from AZ

I have the following formula:
=((LOOKUP($I5,$A$2:$A$7,$D$2:$D$7)-J5)

I'd like to replace $A$2:$A$7 with "NamedRange, Col1" and $D$2:$D$7
with "NamedRange, Col4". How do I create that reference?

Ed
 
go to insert | name | define | names in workbook : col1 | refers to :
A2:A7 | add | ok

similarly for other one.
 
One way:

=LOOKUP($I5,INDEX(NamedRange,,1),INDEX(NamedRange,,4)-J5)

But, more efficient:

=VLOOKUP($I5,NamedRange,4,TRUE)
 
Back
Top