If equals

Good morning!

I'm hoping someone can give me a hand.

This is what I am trying to accomplish:

If a cell within the range of N4:=N53 equals the cells in the range of B6:B36, copy the cell in column B.

For example, if a date within N4:N53 equals the cell in B8, copy the information in C8.

Hopefully that makes sense.

Thanks to both of you!

I tried both, and they aren't really what I am needing (or maybe I am just not doing it right). I need it to do the search and find a match and then copy the information over from the next column.

I have dates on page 2, cells N4:N53. I also have dates on page 1, cells B6:B36. I need it to do a search. If it finds a date in both page 1 and page 2, I need it to copy information. For example, a date on page 2, N15 matches page 1 B6. I then need the information from page 1 C6, copied into the cell that has the formula.

Sorry if I wasn't as clear in the first post. I appreciate any help that you can be.

Thanks!

Hi bro,

try the solution in attachment...


click * to appreciate..

Thanks. I see how that could possible work. However, I see a possible issue with the formula due to the way I have set the rest of it up.

I have reattached your solution with some comments I made. Hopefully it makes it easier for you to understand what I am needing.

Sorry if I was not clearer earlier.

conditional lookup (4).xlsx

hi,

try This
=IFERROR(VLOOKUP(N3,July!$B$2:$C$30,2,0),0)

Punnam

hey bro..
at last your problem is solved...
much easier this time..
no arrays...

check the attachment...

click * if it helps you in someway..

Did that help...?
waiting for reply...

Vikas Gautam

Second Call.xlsSorry for the delayed reply. It has been crazy busy and I didn't have two seconds to look it over unitl now. It still doesn't seem to be working the way I was hoping. I have attached a sample document of what I am working on with a note on Sheet1 as to what I'm hoping to accomplish. Hopefully this makes it easier for you to understand what I am trying to do.
Thanks!

Got the solution..

check the attachment..

very good question instead..


Don't forget to click *, if helped...

Thanks! It appears to be working. Sorry to be a bother again... but I like to learn how it works to be able to use it in other areas in the future. Can you explain what each part of the formula is doing?

Thanks again.... I like to use these roadblocks of mine as a learning opportunity.

Thanks for the feedback..

the best way to learn that how a formula works is using formula evaluation

however I would like to give you a birds eye view of what this formula is doing..

Formula:

Please Login or Register  to view this content.

First of all I would like to clear that the range A4 : A15 in sheet1 is immaterial here..
Now the formula..

Explanation of following part first
(COUNTIF($N$4:$N$53,July!$B$6:$B$36)

countif(Range, Criteria)

this part returns an array of count of each element in July!$B$6:$B$36 in the $N$4:$N$53
It will return an array like this.. {1;0;0;0;0;0;0;0;0;0;0;0;0} (See formula evaluation..)

then I got the position of 1 in that respective array using If(array()>0, Row()) function...

ROW(July!$B$6:$B$36)-ROW(July!$A$5)
the bold part is an correction factor used to refer rows in respective index ie. July!$C$6:$K$6

Then I used Index function to return first value in that respective row in the index (July!$C$6:$K$6) ..
To return other corresponding values, I used Column(A$1) so that when I drag It horizontally I results in next value..

Again the best way to learn is to use Formula evaluation...

I think I have very much managed to explain it..
If not then I am sorry..

Don't forget to click *, if Helped..

Thanks. It does help a lot with me understanding it better. I have added other pages identical to the "July" page. But saying the other months. They are using the exact same cell numbers and everything, but when I change the formula from July to August, it doesn't seem to be working proprely. Is there something else I should be changing in the formula as well to make it work properly.

Sorry to keep bothering you with this problem of mine. I do very much appreciate your assistance on this. I love excel and I love learning more detailed things with it.

Any help someone could be that would be appreciated.

Hi.. Jlo..
can you provide the august worksheet...?

Vikas Gautam

WIP.xls

I have attached the whole document. I am putting the formula you provided me in sheet 1. I have highlighted the ones that are errors to hopefully try and figure out why there are being sent there.

Thanks!

Enjoy..

Click following link if wanna know how countif works in this formula..
https://www.Excel-Buzz.blogspot.in


Don't forget to click *

Thanks for all your help.