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

shan_asa 7 Posts Sunday October 29, 2017Registration date December 5, 2017 Last seen - Oct 29, 2017 at 09:53 AM - Latest reply: shan_asa 7 Posts Sunday October 29, 2017Registration date December 5, 2017 Last seen
- Oct 29, 2017 at 02:01 PM
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
See more 

Your reply

4 replies

Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen - Oct 29, 2017 at 10:39 AM
-1
Thank you
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 7 Posts Sunday October 29, 2017Registration date December 5, 2017 Last seen - Oct 29, 2017 at 10:55 AM
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.
Respond to Mazzaropi
Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen - Oct 29, 2017 at 01:25 PM
-1
Thank you
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 7 Posts Sunday October 29, 2017Registration date December 5, 2017 Last seen - Oct 29, 2017 at 02:01 PM
Thank you very much
Dat was awsom
Respond to Mazzaropi