Lookup question?

hi, Can I do this with lookup in LibreOffice? (i want to exact string from range)

image description

Please retag because your question is neither common (to all LO applications) nor related to the Math formula editor. Remove tags common and math with calc (spreadsheet application).

Do what with LOOKUP()?

Please do not use the Answer field, edit your original question to provide further details. Thanks.

hi, thanks for the reply! my quesion updated

Thanks for updating the tags, but base targets the database Base application. For spreadsheet, the correct tag is calc (corresponding to the Calc application).

Hi @ajlittoz , Thanks for the instructions.

@thegridlock, What do you need to show in A3? z?

See LibreOffice Help on LOOKUP function. Maybe you must use VLOOKUP.

Press edit below your question to add more information. Add Answer is reserved for solutions.