View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JBS JBS is offline
external usenet poster
 
Posts: 11
Default search and return adjacent value

I have a file as follows
3010,123456789,4103,123.56,5101,123
3010,987654321,3011,abcde,4103,15000.00,5103,654
3010,654987321,4103,4523.69,5104,987

I need to search for the value 4103 and return the value after it eg. 123.56