Excel

3 posts / 0 new
Last post
Excel

I have 3 columns with the date in column A and numbers in Column B and C
I need to find numbers in column B and C and return the Date in Column A.
For example if i want to find when 9 in column B is in the same row as 14 in column C and return the date of that event.
Is there a formula for this?

Would 9 and 14 be in

Would 9 and 14 be in different rows? Therefore two dates?

Would 9 and 14 be in

Would 9 and 14 be in different rows? Therefore two dates?

Add new comment