View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Matching 3 columns to 1 cell Matching 3 columns to 1 cell is offline
external usenet poster
 
Posts: 1
Default Match 3 columns to one cell

I have 9-digit account number in the first 3 columns (from A4:C65002) that I
am trying to verify if the number that I have in range D4:d54. I am trying
to use the match function to perform this, but apparently the match function
will NOT match between 3 columns only one column.

Is there a way to perform this function that I am trying to do??