View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ardus Petus
 
Posts: n/a
Default VLookup function to right!

=INDEX(B3:B8,MATCH(B13,D3:D8,0))

HTH
--
AP

a écrit dans le message de news:
...
I have a sheet with 5 colums,

A B C D 1
B C D E 2
C D E F 3

What I want is, using the vlookup function to right!
So the numbers are the lookup value

=VLOOKUP(B13,B3:G8,-2,FALSE)

If I use this, I get an error.

Who can help me???

Greets