• 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.

Using Lookup(aaa,bbb) to show result of after number instead of before

B

bigjohn

New Member
=Lookup(aaa,Column 1)


Column 1 consists of number 2, 4, 6, 8, 10, 12, 14, 16, 18, 20.


Full list of aaa is from 1 to 20.


The only formula error is:

=Lookup(1, Column 1)

=#N/A


How to get the formula to show result as 2? Result of 0 is not allowed.
 
Hi Bigjohn,


Col 1 Col 2 Col D Col E (Formula)

aaa 1 aaa =VLOOKUP(C2,$A$2:$B$7,2,0)

bbb 2 bbb =VLOOKUP(C3,$A$2:$B$7,2,0)

ccc 3 ccc =VLOOKUP(C4,$A$2:$B$7,2,0)

ddd 4 ddd =VLOOKUP(C5,$A$2:$B$7,2,0)

eee 5 eee =VLOOKUP(C6,$A$2:$B$7,2,0)

fff 6 fff =VLOOKUP(C7,$A$2:$B$7,2,0)


Thanks,

Suresh Kumar S
 
You must log in or register to reply here.
Back
Top