Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |