We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

display results from another sheet [closed]

asked 2016-03-30 18:01:50 +0200

JamesNavy gravatar image

updated 2020-09-02 01:33:24 +0200

Alex Kemp gravatar image

Bare with me as i am new to this site as well as LibreOffice.

there are hundreds of subject IDs and more will be entered in the future, so what i need is to display Sheet1's column information based off of what ID i enter into row one on sheet7.

I will describe this the best i can. currently i have 6 sheets and i want to make sheet 7 to display information based off of sheet 1 in sheet 7 row B1-AMJ. i want to type in a subjects ID in sheet 7 row B1-onward and display in the corresponding column information from sheet 1.

so far ive been using HLOOKUP formula but it only displays the first 2 lines in the column and the rest are #N/A the code ive been using is =HLOOKUP(B2, Volume_mm3.$B$1:$B$50,2) i think i am on the right track but i could be horribly wrong.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-09-02 15:07:54.985705

1 Answer

Sort by » oldest newest most voted

answered 2016-03-30 21:58:13 +0200

LKeithJordan gravatar image

It is hard to fully grasp what you are describing, but based on what I can surmise, here are my recommendations:

First, try VLOOKUP instead of HLOOKUP. Your description leads me to believe VLOOKUP is the function for which you are searching.

Second, the amount of data you describe might be better served by a relational database than a spreadsheet. Luckily, LO Base is available. However, I would use Firebird or some other engine for Base. HSQLDB is Java-based and I would not use it.

I hope this helps.

Please click the checkmark next to the response you believe best answers your question.

edit flag offensive delete link more

Question Tools



Asked: 2016-03-30 18:01:50 +0200

Seen: 47 times

Last updated: Mar 30 '16