Refer to NamedRange, Col1 in formula to find value?

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
 
M

muddan madhu

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

similarly for other one.
 
J

JE McGimpsey

One way:

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

But, more efficient:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display weeks from a Milestone 0
Adding sequence numbers to paragraphs 0
Modify data going to DAverage function 3
Using FIND to highlight text (with dashes) 4
SUM 2 COLumns values with common names in another columns 3
Index match with multiple criteria(different than usual) 0
Index match with multiple criteria(different than usual) 3
How to use/create code in MS Word to calculate age? 0

Top