Please follow the instruction hope this will help you.

1) Tools

2) Options

3) Calc

4) Calculation...

"Regular Expressions" = ON

=VLOOKUP(LEFT(E10;70)&".*";Lists.$B$1:$F$203;2;0)

Thanks,

Statistics: Posted by SteveJ — Mon Jul 07, 2014 11:40 am

]]>

Please follow the instruction hope this will help you.

1) Tools

2) Options

3) Calc

4) Calculation...

"Regular Expressions" = ON

=VLOOKUP(LEFT(E10;70)&".*";Lists.$B$1:$F$203;2;0)

Thanks,

Statistics: Posted by SteveJ — Mon Jul 07, 2014 11:40 am

]]>

I use a spreadsheet at work on excel and it works perfectly. I now work for a new company who use Open Office and the formula does not work.

Would someone be able to help me, I have very little knowledge of Open Office and limited knowledge of excel so please explain in as much detail as possible.

The formula i am currently using on excel is =VLOOKUP(LEFT(E10,70)&"**",Lists!$B$1:$F$203,2,0)

Basically if I select an item from a drop down list in cell E10, this puts a value that relates to the item selected in cell F10. The drop down list and the value that relates to it is stored on a different page(tab) named Lists.

for some reason I am not able to attach the file,

Thanks in advanced for any help/advice.

Statistics: Posted by Ricky G. Marion — Mon Jul 07, 2014 9:05 am

]]>