If formula for range of cells

[WVbzn]

I have two tabs of a worksheet. I want to see if the number I have in B2 matches any of the numbers on the second tab in the range B2:B10. If the one number in B2 does match any of the numbers in B2:B10, I want the cell to populate with a corresponding value in C2:C10. So, I have ID numbers for cases listed on the first tab in column B. I have those same type of numbers for cases listed on the second tab in column B of the second tab. In column C on the second tab, I have dates. If the case ID on the first tab matches any of the case IDs on the second tab, I want the corresponding (so same row as the matching ID) date in the column next to it. If there is no match for the case ID on the first tab, it should populate the cell with "no". Any suggestions?

[Pete_UK]

Put this in C2 of the first sheet:

=IFERROR(VLOOKUP(B2,Sheet2!$B$2:$C$10,2,0),"no")

Format the cell as Date in the style you prefer. You can copy the formula down if you have other IDs in column B.

Hope this helps.

Pete

[WVbzn]

Awesome! That worked! Thanks so much for your help!

[arlu1201]

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.