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

Report
Posts
7
Registration date
Sunday October 29, 2017
Status
Member
Last seen
December 5, 2017
-
shan_asa
Posts
7
Registration date
Sunday October 29, 2017
Status
Member
Last seen
December 5, 2017
-
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

5 replies

Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
131
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
Posts
7
Registration date
Sunday October 29, 2017
Status
Member
Last seen
December 5, 2017

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.
Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
131
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
Posts
7
Registration date
Sunday October 29, 2017
Status
Member
Last seen
December 5, 2017

Thank you very much
Dat was awsom