| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup with the same values in one column
Duke, When I said 4.96 I ment 3.96.
"Duke Carey" wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup- 5 values to be displayed in another column as different T | Excel Discussion (Misc queries) | |||
| Vlookup with Multiple like values in the reference column | Excel Worksheet Functions | |||
| adding up vlookup values in one column and in between them | Excel Discussion (Misc queries) | |||
| adding up vlookup values in one column and in between them | Excel Worksheet Functions | |||
| vlookup with all the same values in one column | Excel Discussion (Misc queries) | |||
Threaded Mode
