| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Vlookup using two criteria -not working
Hello,
Could you please refer the attached worksheet and kindly suggest a formula to look up values using two criterias. I used index, match functions and they dont seem to work. Please help Regards, Dumbo |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Vlookup using two criteria -not working
Hi,
Am Mon, 12 Nov 2012 08:43:43 +0000 schrieb Excel Dumbo: Could you please refer the attached worksheet and kindly suggest a formula to look up values using two criterias. in C3 try: =INDEX('Look UP Data'!D$1:D$100,MATCH($B$2&$B3,'Look UP Data'!$C$1:$C$100&'Look UP Data'!$A$1:$A$100,0)) and enter the array formula with CTRL+Shift+Enter Then copy the formula to right and down. Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
|
#3
|
|||
|
|||
|
THanks a lot Claus. It worked.
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If (Vlookup 0) working, but what if Vlookup cell does not exist | Excel Worksheet Functions | |||
| AverageIF with cell refenrence as criteria is not working | Excel Discussion (Misc queries) | |||
| SUMIF/PRODUCT with multiple Criteria not working | Excel Discussion (Misc queries) | |||
| Delete Rows based on criteria in Column A (not working) | Excel Programming | |||
| Sumproduct w/date criteria not working | Excel Worksheet Functions | |||
Linear Mode
