• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

auto add rowes

L

lynnbergeron_no

New Member
How do I auto add to a formula? For example: = lookup(2/1(a2:a5=d2),c2:25)

If I add data pass “A5” the formula will not take into account the added data. How can I write a formula that will do that?
 
The most straightforward approach, which is consistent with most modern functionality, is to turn A1:C5 into a table. Then you can use formulae such as
=LOOKUP( 1, 1/(Table1[Column1]=Criterion),Table1[Column3])
and have the table grow and, as you add data, the structured references update automatically.
 
You must log in or register to reply here.
Back
Top