Searching for cell data

[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

[Saarang84]

Can u post a workbook with sample data? Also include how do you want the output to look like.

[MrShorty]

Will your lookup value always match your data table exactly? I might suggest using the VLOOKUP() function instead: http://office.microsoft.com/en-us/ex...011.aspx?CTT=1 As explained in the help file, with the fourth argument set to FALSE, you can use wildcard characters in your lookup value. So, something like =VLOOKUP("PR1420829*",$D$5:$L$381,9,FALSE) will return from the row containing the first record that starts with PR1420829.