Thread: finding values
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
italiavb italiavb is offline
external usenet poster
 
Posts: 19
Default finding values

C...think you can make this happen?

"Tom Ogilvy" wrote in message
...
Is this row by row - so if there is a match it is on the same row. If
not,
then which row in column E should be used? Adjacent to the cell in A or
C.



--
Regards,
Tom Ogilvy


"italiavb" wrote in message
...
I have 5 columns of information. Column A and C are text; B and D are
numbers. I need to match a text string in column C to the same string in
column A. When a match is found, subtract the value in the adjacent cell

in
column D from the value in column B. put the result in column E. Can

anyone
help?