View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
herb herb is offline
external usenet poster
 
Posts: 8
Default 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