View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JeffATC JeffATC is offline
external usenet poster
 
Posts: 4
Default Compare cells and grab if matched

I am trying to compare 2 columns D and H The columns contain dollar amounts.
If a $ amount in 1 cell matches a $ amount in the other then I want to have
it grab both of those cells plus the 3 cells to the left of the matches. I
would really appreciate anyones help or suggestions.
Thanks