Help moving from Excel (VLOOKUP)

General discussion on OpenOffice Calc and its spreadsheets.

Help moving from Excel (VLOOKUP)

Postby Ricky G. Marion » Mon Jul 07, 2014 9:05 am

Hi,

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.
Ricky G. Marion
 
Posts: 25
Joined: Mon Mar 24, 2014 6:33 am

Re: Help moving from Excel (VLOOKUP)

Postby SteveJ » Mon Jul 07, 2014 11:40 am

Hello,

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,
SteveJ
 
Posts: 20
Joined: Tue Mar 25, 2014 6:31 am

Re: Help moving from Excel (VLOOKUP)

Postby SteveJ » Mon Jul 07, 2014 11:40 am

Hello,

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,
SteveJ
 
Posts: 20
Joined: Tue Mar 25, 2014 6:31 am


Return to OpenOffice.org Calc

Who is online

Users browsing this forum: No registered users and 1 guest

cron