Excel Formula – partial look up

[matt_boy83]

Hi there, i am hoping someone might be able to help.

I am currently trying to figure out a way to look up any cells with in a data dump (example: PR1420829-V2) but not having to include the 'V2' but still picking up the cell.

Im currently using the fomula;

=IF(ISNA(LOOKUP($D$5:$D$1000,Test!$C:$C,Test!$L$1:$L$381)),"",LOOKUP($D$5:$D$1000,Test!$C:$C,Test!$L$1:$L$381))

I hope this makes sense, thanks

Matt

[TPDave]

Please post a sample workbook.

Thanks

[matt_boy83]

Finance Report - Test.xlsx

This should now be attached

Thanks