Solved

# Excel Look up Function

Posted on 2014-03-23
260 Views
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
0
Question by:p-plater
• 2
• 2

LVL 15

Expert Comment

=if(\$c3=2,\$c\$2,if(\$d3=2,\$d\$2,if(\$e3=2,\$e\$2)))

Try this
0

LVL 29

Accepted Solution

gowflow earned 500 total points
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

LVL 15

Expert Comment

Elegant, gowflow!
0

Author Closing Comment

Absolutely excellent

Top job
0

LVL 29

Expert Comment

gowflow
0