Report

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
Helpful
+1
plus moins
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 - Oct 29, 2017 at 02:01 PM
Thank you very much
Dat was awsom
Reply
Leave a comment
Helpful
-1
plus moins
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 - 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.
Reply
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!