LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 6
Default 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.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 02:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"