Forum Discussion
Solved
Lookup for value between two values
Hi Guys/Girls, I have big problem for me but small for you, I hope. I have 2 tables, in first one I have registered some values and I would like to get one value from the second table: my fi...
Tomaz9x since you seem to be working in the R1C1-reference style that ould be like in the first picture below.
Formula used:
=LOOKUP(RC[-1],RC[2]:R[2]C[2],RC[4]:R[2]C[4])If, on the other hand you would chose for the default reference style, you would end up with a formula like this:
=LOOKUP(G1,J1:J3,L1:L3)
Tomaz9x since you seem to be working in the R1C1-reference style that ould be like in the first picture below.
Formula used:
=LOOKUP(RC[-1],RC[2]:R[2]C[2],RC[4]:R[2]C[4])If, on the other hand you would chose for the default reference style, you would end up with a formula like this:
=LOOKUP(G1,J1:J3,L1:L3)
- Hello Riny_van_Eekelen,
I was thinking how to compare between two columns, but now I see that is enough if I search just by one column.
Regards
Tomaz
