Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match/Vlookup/Hlookup ?
Not sure what formula to use when trying to match two criteria and having
them pinpoint a cell depending on teh criteria. I need the formula to go out and look for "Vermont" in the row and "Mar" in the column and give me '234'. Texas California Vermont Ohio Iowa Oct 10 5 4 3 2 Nov 38 20 50 90 7 Dec 40 35 96 177 12 Jan 41 50 142 264 17 Feb 56 65 188 351 22 Mar 65 80 234 438 27 Apr 75 95 280 525 32 May 85 110 326 612 37 Jun 94 125 372 699 42 Jul 104 140 418 786 47 Thanks!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match/Vlookup/Hlookup ?
try it...
=VLOOKUP("Mar",I22:N32,MATCH("Vermont",{"Texas","C alifornia","Vermont","Ohio","Iowa"},0)+1,0) HTH "Daniel Q." wrote: Not sure what formula to use when trying to match two criteria and having them pinpoint a cell depending on teh criteria. I need the formula to go out and look for "Vermont" in the row and "Mar" in the column and give me '234'. Texas California Vermont Ohio Iowa Oct 10 5 4 3 2 Nov 38 20 50 90 7 Dec 40 35 96 177 12 Jan 41 50 142 264 17 Feb 56 65 188 351 22 Mar 65 80 234 438 27 Apr 75 95 280 525 32 May 85 110 326 612 37 Jun 94 125 372 699 42 Jul 104 140 418 786 47 Thanks!! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match/Vlookup/Hlookup ?
It's giving me a #REF!.
dsq "Andri" wrote: try it... =VLOOKUP("Mar",I22:N32,MATCH("Vermont",{"Texas","C alifornia","Vermont","Ohio","Iowa"},0)+1,0) HTH "Daniel Q." wrote: Not sure what formula to use when trying to match two criteria and having them pinpoint a cell depending on teh criteria. I need the formula to go out and look for "Vermont" in the row and "Mar" in the column and give me '234'. Texas California Vermont Ohio Iowa Oct 10 5 4 3 2 Nov 38 20 50 90 7 Dec 40 35 96 177 12 Jan 41 50 142 264 17 Feb 56 65 188 351 22 Mar 65 80 234 438 27 Apr 75 95 280 525 32 May 85 110 326 612 37 Jun 94 125 372 699 42 Jul 104 140 418 786 47 Thanks!! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match/Vlookup/Hlookup ?
Hi,
you can try to use the INDEX and MATCH function: =index(A1:F11,match("Mar",A1:A11,0),match("Vermont ",A1:F1,0) -- Regards, Ashsih Mathur Microsoft Excel MVP www.ashishmathur.com "Daniel Q." wrote in message ... Not sure what formula to use when trying to match two criteria and having them pinpoint a cell depending on teh criteria. I need the formula to go out and look for "Vermont" in the row and "Mar" in the column and give me '234'. Texas California Vermont Ohio Iowa Oct 10 5 4 3 2 Nov 38 20 50 90 7 Dec 40 35 96 177 12 Jan 41 50 142 264 17 Feb 56 65 188 351 22 Mar 65 80 234 438 27 Apr 75 95 280 525 32 May 85 110 326 612 37 Jun 94 125 372 699 42 Jul 104 140 418 786 47 Thanks!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HLOOKUP or VLOOKUP or Index or Match or WHAT? | Excel Discussion (Misc queries) | |||
HLOOKUP, VLOOKUP, MATCH, INDEX - Help with the Right Solution! | Excel Discussion (Misc queries) | |||
vlookup, sumproduct, hlookup, index match, not sure | Excel Discussion (Misc queries) | |||
VLookUp or HLookUp Plus Index - Match, I think??? | Excel Worksheet Functions | |||
Vlookup / Match / Hlookup / Array fundtion or What? | Excel Discussion (Misc queries) |