select last entry

[lynnbergeron_no]

I the following formula and they will have multiple matches. I would like it to select the last match in the “Entry Sheet”. Also, I will be adding data to the "Data Entry" sheet time to time. So, formula will have to self adjust the range .



=IF(D$1="","", IF($A2="","", IF(ISERROR(VLOOKUP($A2&D$1,'Entry Sheet'!$E:$F,2,FALSE)),"-",(VLOOKUP($A2&D$1,'Entry Sheet'!$E:$F,2,FALSE)))))

 

[p45cal]

try:

=IF(D$1="","", IF($A2="","", IF(ISERROR(LOOKUP(2,1/('Entry Sheet'!$E:$E=$A2&D$1),'Entry Sheet'!$F:$F)),"-",LOOKUP(2,1/('Entry Sheet'!$E:$E=$A2&D$1),'Entry Sheet'!$F:$F))))

What version of Excel are you using? This formula could be considerably shortened.

 

[lynnbergeron_no]

version 2007 it did not work.

 

[p45cal]

I'd be very surprised, I tested it here first and none of the functions I used are missing from Excel 2007.
The next step is for you to supply a little workbook with these sheets in with some original formulae in, and if you want, my suggested formula not working too.
Which way will you be copying the formula? Across or down?

You could give a bit more information than 'did not work'.