Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLook UP formula question
I need to write a vlookup on two variables.
I need it to match two variables (column A and column C) then go over five columns for the answer. Col. A Col. B Col. C Col. D Col. E Col. F Month ID Name ..... Value |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLook UP formula question
Assuming your data starts in row 2 (with headers in row 1) and extends
down to row 100 =INDEX(F1:F100,MATCH(1,("Month"=A1:A100)*("ID"=B1: B100),0)) This is an array formula, use Ctrl-Shift-Enter to execute. If you put the variables into separate cells (put month in H1 and Name in I1) you can generalize the formula, for example: =INDEX(F1:F100,MATCH(1,(H1=A1:A100)*(I1=B1:B100),0 )) HTH, JP On Nov 16, 11:00 am, Scott@CW wrote: I need to write a vlookup on two variables. I need it to match two variables (column A and column C) then go over five columns for the answer. Col. A Col. B Col. C Col. D Col. E Col. F Month ID Name ..... Value |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLook UP formula question
Scott,
If there is a unique combo of month and names, then use something like =INDEX(F:F,SUMPRODUCT((A1:A1000 = "January")*(C1:C1000="Name")*ROW(A1:A1000))) This assumes that the Month in column A are string, and not formatted dates. HTH, Bernie MS Excel MVP "Scott@CW" wrote in message ... I need to write a vlookup on two variables. I need it to match two variables (column A and column C) then go over five columns for the answer. Col. A Col. B Col. C Col. D Col. E Col. F Month ID Name ..... Value |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOK-pivot table expanding want to update vlook automatically | Excel Worksheet Functions | |||
VLOOK-pivot table expanding want to update vlook automatically | Excel Worksheet Functions | |||
VLook Up Formula | Excel Discussion (Misc queries) | |||
Vlook up question - I think ? | Excel Discussion (Misc queries) | |||
vlook up and if formula | Excel Worksheet Functions |