Excel Look up Function

Hello

I need a formula to fill in the date in column B when there is a Value of 2 in the row
So Name 1 should have a Last Visit date of 03/03/2014 Name 2 02/02/2014 and Name 3 03/03/2014

The date needs to be the Date in row 2 that is above the FIRST value of 2 that is in that row.
Needs to be dynamic so I can drag it down a couple of thousand rows

Thanks
Visit-Date.xlsx
p-platerAsked:
Who is Participating?
 
gowflowCommented:
Put this formula in B3 and Drag it down as much as you have data. I have set the Columns to go till Col Z but if you have more dates beyond Col Z change the Z to the last Column of data.

Put this Formula in B3 and drag it down.
=IFERROR(LARGE($C$2:$Z$2,MATCH(2,C3:Z3,0)),"")

Congratulation on your Icon Conditional formatting very neat.
gowflow
Visit-Date.xlsx
0
 
Darrell PorterEnterprise Business Process ArchitectCommented:
=if($c3=2,$c$2,if($d3=2,$d$2,if($e3=2,$e$2)))

Try this
0
 
Darrell PorterEnterprise Business Process ArchitectCommented:
Elegant, gowflow!
0
 
p-platerAuthor Commented:
Absolutely excellent

Top job
0
 
gowflowCommented:
your welcome. glad I could help.
gowflow
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.