View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
J-EL J-EL is offline
external usenet poster
 
Posts: 4
Default Which function to choose?

Hello - I would appreciate some help choosing the best function for matching
columns of data. I have my data set up like this in 4 columns:
5.05 AAAAAAAA 5.00 ZZZZZZZZZ
5.00 ZZZZZZZZZ 4.95 XXXXXXXX
4.95 XXXXXXXX 5.05 AAAAAAAA
Where I'd like to have a column on the side which returned a YES or NO if,
for example, "AAAAAA" on each side both had the 5.05 next to it. If not, like
if AAAA on one said 5.2 and the other said 5.05, then to return a NO.

You guys have been so helpful in the past, and I'd really appreciate
anything someone can offer. Cheers!