formula for an unknown number

[karwanbk]

hi ,

i have an unknown rows so i want made a formula for it like

A B C

1 2
3 9
7 3
8 2
22 1
39 2

i put this formula in C
=VLOOKUP(1,CHOOSE({1,2},A:A,B:B),2,FALSE)

Because i don't know how much rows in A and B , so i want check all of it whatever the number of it .

thanks

 

[Jonmo1]

I don't understand what's wrong with a standard vlookup?

=VLOOKUP(1,A:B,2,FALSE)

?

 

[karwanbk]

Thanks for your replay now works

 

[Jonmo1]

You're welcome.