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

[bigjohn]

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

 

[sdsurzh]

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

 

[bigjohn]

Thank you.


Problem solved.