# How to compare a range of data in Excel? [Solved]

Ask a question shan_asa 5Posts Sunday October 29, 2017Registration date November 7, 2017 Last seen - Last answered on Oct 29, 2017 at 02:01 PM by shan_asa
Dear Team,

I want to compare a range of values from columns in row A (A1 to A6) with date input in column C1. If C1 is equal to data in A1 then D1 should reflect B1 and if C1 is equal to A2 then D1 should reflect B2
+1
shan_asa,
I believe that this time it was possible to correctly understand your doubt.

Try to use:

=INDEX(B1:B6, MATCH(C1,A1:A6,0))

I hope it helps
--
Belo Horizonte, Brasil.
Marcílio Lobão
shan_asa 5Posts Sunday October 29, 2017Registration date November 7, 2017 Last seen -
Thank you very much
Dat was awsom
-1
shan_asa, Goodmorning.

Try to do:

D1 --> =IF(A1=\$C\$1, B1, "")

Copy it down as necessary.

Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
shan_asa 5Posts Sunday October 29, 2017Registration date November 7, 2017 Last seen -
Good Morning Mazzaropi,

In the above formula u gave it is jus comparing A1 and C1. But what I require is the C1 value has to check A1 to A6 and then provide date to column D1. That is if C1 = A1 then D1 should be B1, if C1 = A2 then D1 should be B2 and so on.
Hope you understood what I want.