View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cohutta Cohutta is offline
external usenet poster
 
Posts: 1
Default how do I move a cell based on a match of another cell in excel?

I have two lists of customer sales info and I want to line them up on a given
row based on customer number (columns A and E). I know about the vlookup
function, but I want to move, not copy the data. That way I can identify
those is the second group (column E) that did not have a match in the first
group (column A).