View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
m m is offline
external usenet poster
 
Posts: 64
Default V look up/H look up/

Hi

I am trying to create a formula which I have no idea about. Based on the
example below can someone please help.

I have an array (eg A3:F30) where each row is a unique series of numbers.
eg 5.555,106.45, 57, 33.66, 8765, 33,

I want to be able to check each unique series (row) of numbers in the array
against another singular series of numbers (row) of numbers and if there is
match then put an identifiying mark (e.g T, 0 or 'match') in the column
adjacent to the row to the ones that match with my array.

Can someone tell me how to do this?

thanks