View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Duke Carey Duke Carey is offline
external usenet poster
 
Posts: 1,081
Default 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