Home |
Search |
Today's Posts |
#1
|
|||
|
|||
one more time index/match
I know I asked this same type of question yesterday but for some reason I cannont get it to work. Here is my problem: B2 – has a list to choose from either 5kv, 15kv, 25kv, … B3 – has a list also to choose from 8, 10, 12, 500 B4 – here is my problem: I need B4 to look up B2 and match the size to sheet2 column B Then take the value in B3 match it with the value in sheet2 column D And input the number located in column F in that same row across. I am pretty sure this can be done but I am having a hard time trying to index and match where I need to find two values from two comumns. Thanks for the help.. -- MIKE0W ------------------------------------------------------------------------ MIKE0W's Profile: http://www.excelforum.com/member.php...o&userid=21465 View this thread: http://www.excelforum.com/showthread...hreadid=379296 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
time differences in a column | Excel Worksheet Functions | |||
Accumulate weekly time to total time in Excel. | Excel Discussion (Misc queries) | |||
Time Sheet Calculation Help Needed! | Excel Worksheet Functions | |||
Time Sheets | Excel Discussion (Misc queries) | |||
unmet challenge | Excel Worksheet Functions |