What formula do I use?
 

I thought I had posted a question pertaining to this problem a while back,
but could not locate it to see if it had been answered... how can I locate
old posts that I have entered?

In Sheet 2, I have three columns X multiple rows of data. Column A has
multiple common entries, and column B also has multiple common entries. But
the combination of Column A and Column B are never the same.
Based on this, I want to enter variables for Col A (variable 1) and also for
Col B (variable 2), and return the value in a cell in Col C that aligns with
variable 1 & 2.

Example: If I enter var 1 = 1.315, and var 2 = 1.8, return value in Col C
(1.049).
Col A Col B Col C
1.315 1.7 1.049
1.315 1.72 1.049
1.315 1.8 1.049
1.660 2.1 1.38
1.660 2.3 1.38
1.660 2.33 1.38

Not sure what function or combination of functions I would use.

What formula do I use?
 

If you do not have too many posts you can search for 'HammerD'...
or on content you remember.

Can you insert a Col before Col A in Sheet1? If yes, then do that and enter
this in A1
=B1&C1
and copy down...

Now if (on Sheet1) A1 has var1 and B1 has var2
enter this in C1
=VLOOKUP(A1&B1,Sheet2!A:D,4,FALSE)

You can copy it down...

"HammerD" wrote:

I thought I had posted a question pertaining to this problem a while back,
but could not locate it to see if it had been answered... how can I locate
old posts that I have entered?

In Sheet 2, I have three columns X multiple rows of data. Column A has
multiple common entries, and column B also has multiple common entries. But
the combination of Column A and Column B are never the same.
Based on this, I want to enter variables for Col A (variable 1) and also for
Col B (variable 2), and return the value in a cell in Col C that aligns with
variable 1 & 2.

Example: If I enter var 1 = 1.315, and var 2 = 1.8, return value in Col C
(1.049).
Col A Col B Col C
1.315 1.7 1.049
1.315 1.72 1.049
1.315 1.8 1.049
1.660 2.1 1.38
1.660 2.3 1.38
1.660 2.33 1.38

Not sure what function or combination of functions I would use.

What formula do I use?
 

Thanks - that did the trick!




"Sheeloo" wrote:

If you do not have too many posts you can search for 'HammerD'...
or on content you remember.

Can you insert a Col before Col A in Sheet1? If yes, then do that and enter
this in A1
=B1&C1
and copy down...

Now if (on Sheet1) A1 has var1 and B1 has var2
enter this in C1
=VLOOKUP(A1&B1,Sheet2!A:D,4,FALSE)

You can copy it down...

"HammerD" wrote:

I thought I had posted a question pertaining to this problem a while back,
but could not locate it to see if it had been answered... how can I locate
old posts that I have entered?

In Sheet 2, I have three columns X multiple rows of data. Column A has
multiple common entries, and column B also has multiple common entries. But
the combination of Column A and Column B are never the same.
Based on this, I want to enter variables for Col A (variable 1) and also for
Col B (variable 2), and return the value in a cell in Col C that aligns with
variable 1 & 2.

Example: If I enter var 1 = 1.315, and var 2 = 1.8, return value in Col C
(1.049).
Col A Col B Col C
1.315 1.7 1.049
1.315 1.72 1.049
1.315 1.8 1.049
1.660 2.1 1.38
1.660 2.3 1.38
1.660 2.33 1.38

Not sure what function or combination of functions I would use.