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

search in first column return value from second column same row
 

VLOOKUP()

Tim

"herb" wrote in message
oups.com...
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

search in first column return value from second column same row
 

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