Indirect Lookup Other Worksheet

Try this ...

=LOOKUP(B2,CHOOSE(A2,Sheet1!$A$2:$B$5,Sheet1!$A$6:$B$9,Sheet1!$A$10:$B$13))

Originally Posted by Phuocam

Try this ...

=LOOKUP(B2,CHOOSE(A2,Sheet1!$A$2:$B$5,Sheet1!$A$6:$B$9,Sheet1!$A$10:$B$13))

I want to make use of the cells A2 to A4. Something like...

C2=Lookup(B2, indirect(Sheet1!("A$"&(A2*4-2):"A$"&(A2*4+1)), indirect(Sheet1!("B$"&(A2*4-2):"B$"&(A2*4+1))