search in first column return value from second column same row

hi all,

i try to make a kind of mapping from a external vb application. from
this application i want to open a .csv file, search for a string in the
first column and return the string from the second column in the same
row.

like this:

searchstring: "test"


1. column 2.column

monday january
tuesday february
wendsday march
..... .....
..... ......
.... ......
test testback
......
......
......
a.s.o


to the application the string "testback" should be returned....


some ideas?


thanks in advance,
herb

VLOOKUP()

Tim

"herb" <[email protected]> wrote in message
news:[email protected]...
> hi all,
>
> i try to make a kind of mapping from a external vb application. from
> this application i want to open a .csv file, search for a string in the
> first column and return the string from the second column in the same
> row.
>
> like this:
>
> searchstring: "test"
>
>
> 1. column 2.column
>
> monday january
> tuesday february
> wendsday march
> .... .....
> .... ......
> ... ......
> test testback
> .....
> .....
> .....
> a.s.o
>
>
> to the application the string "testback" should be returned....
>
>
> some ideas?
>
>
> thanks in advance,
> herb
>

sorry i posted this maybe to the wrong ng.....