LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 11:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"