Thread
:
VLookup function to right!
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Ardus Petus
Posts: n/a
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
Reply With Quote