Insert value from chart that matches another cell value

Discuss the spreadsheet application

Insert value from chart that matches another cell value

Postby Jedi » Sun May 05, 2019 10:26 am

In cell D2 i'd like the value from the I column where the H column matches with the value from cell B2, so with current values it would enter 0.026 into D2 and if I changed b2 to 0.8 D2 would display .024
Hopefully you can see my image below as its difficult for me to explain.

Capture.png
Openoffice 4.1.0 on Win 10
Jedi
 
Posts: 6
Joined: Wed Jun 15, 2016 7:21 am

Re: Insert value from chart that matches another cell value

Postby robleyd » Sun May 05, 2019 10:48 am

VLOOKUP appears to be what you need. [Tutorial] VLOOKUP questions & answers
Cheers
David
Apache OpenOffice Developer Build 4.2.0 9820 - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 2884
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia


Return to Calc

Who is online

Users browsing this forum: No registered users and 14 guests