[Solved] Copy data from sheet to sheet

[terenceM]

Need Help for a function or formula.
I have data on a Sheet 1 and I'm wanting to enter data on sheet 2 and have it take that information look in sheet 1 and return the value of the column and row intersection. I've been trying the index match function, but with no luck.

[terenceM]

In sheet 2 (Data) I am using the data entered into column B to correspond to the data in Column A in sheet 1 (Temp VPD). Then the data entered in column C of sheet 2 to correspond to the cells in Row 8 of sheet 1. I would then like it to respond with the value of the row and column intersection. For example; if I entered the data on sheet 2 as 77º and 60% the return value should be 1.08. I have it represented by the blue lines one sheet 1. I. hope this is what you wanted.

[Zizi64]

I have named the data ranges in your sample file :
MyTemp = A8:A25
MyData = A8:S25

Then you can use the functions Hlookup() and the Match()

Code: Select all

=HLOOKUP(C3;MyData;MATCH(B3;MyTemp);0)

Temp RH _ Zizi64.ods

(45.16 KiB) Downloaded 50 times

If you want to interpolate between two existing Temp and Humidity values, then it will be more difficult.

[Alex1]

Values with a degree symbol are treated as text. You cannot use them in calculations.

[terenceM]

Zizi64,
Thank you for your help, that function worked for what I was trying to do.