Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Multiple vlookup arguments
Does anyone know the solution to the following problem? I have data with three columns. The first column is a spatial ID column, the second a depth column. For any given ID there are multiple depth values (i.e. there are repeating ID's for a number of different depth values). The third column is a results column. I then want to compare a given ID and depth to the 3 columns and return the result. I want to creat a formula that compares both my ID to the ID column and my depth to the depth column to get the correct result. I've tried different vlookup, and, if, and array combinations to no avail. anyone? Thanks Ian -- ichall ------------------------------------------------------------------------ ichall's Profile: http://www.excelforum.com/member.php...o&userid=28214 View this thread: http://www.excelforum.com/showthread...hreadid=477640 |
#2
|
|||
|
|||
Multiple vlookup arguments
Assumptions:
A1:A10 contains the ID B1:B10 contains the Depth C1:C10 contains the Result Formula: =INDEX($C$1:$C$10,MATCH(1,($A$1:$A$10=E1)*($B$1:$B $10=F1),0)) ....where E1 contains the ID of interest, and F1 contains the Depth of interest. The formula needs to be confirmed with CONTROL+SHIFT+ENTER, not just ENTER. Hope this helps! In article , ichall wrote: Does anyone know the solution to the following problem? I have data with three columns. The first column is a spatial ID column, the second a depth column. For any given ID there are multiple depth values (i.e. there are repeating ID's for a number of different depth values). The third column is a results column. I then want to compare a given ID and depth to the 3 columns and return the result. I want to creat a formula that compares both my ID to the ID column and my depth to the depth column to get the correct result. I've tried different vlookup, and, if, and array combinations to no avail. anyone? Thanks Ian |
#3
|
|||
|
|||
Multiple vlookup arguments
thanks Ian -- ichall ------------------------------------------------------------------------ ichall's Profile: http://www.excelforum.com/member.php...o&userid=28214 View this thread: http://www.excelforum.com/showthread...hreadid=477640 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP and multiple columns | Excel Discussion (Misc queries) | |||
how do I use vlookup for multiple occurrences of the same value | Excel Worksheet Functions | |||
Can VLOOKUP return multiple answers based on several identical lo. | Excel Worksheet Functions | |||
vlookup with multiple lines of same value | Excel Worksheet Functions | |||
vlookup over multiple worksheets | Excel Worksheet Functions |