Lookup

[jgrim]

We are trying to find a number that is in a 2 column table, but the number that we want to find is in the second column. We tried using the v-lookup but it gave the result from the first column.

for example:
1 5
2 4
3 3
4 2
5 1
We want a formula that will find the number 2 in the second column and return the value of 4 from the first column.

[martindwilson]

=vlookup(2,a1:b100,2,false)
oops 2nd to first then you need
index(a:a,match(2,b:b,0))