vlookup with the same values in one column
If you are asking how to use 2 values as lookups, i.e., find the row where
the first lookup value matches column A and the second lookup value matches
column B, and get the value in column C, then:
If column C contains numeric values AND IF the combinations in A & B are
guaranteed to be unique:
=sumproduct(--(A5:A100=A1),--(B5:B100=B1),(C5,C100)
If column C contains text values or numeric values AND IF the combinations
in A & B are guaranteed to be unique:
*this is an array formula to be entered by pressing Ctrl-Shift-Enter*
=INDEX(C5:C100,MATCH(A1&B1,A5:A100&B5:B100,0))
"mike" wrote:
Here is an example of what I am trying to lookup:
column A column B column C
3.00 4.00 2.95
3.00 4.50 3.00
I am trying to do a lookup by punching a value into a cell which would be in
column A and also a value into another cell which would be in column B to
give me the value in the correct coumn C. I tried this,
=VLOOKUP(G3,A2:D3,3). How do i do this?
-Mike
|