Multiple vlookup //

[Guest]

Hi . How can we use the vlookup function to get the output (result) based on
multiple inputs mentioned in diff worksheets.
The result could be pulled from a table like mentioned below :
Week Area TPT
Wk36 1 A
Wk37 1 A
Wk38 1 A
Wk39 1 A
Wk40 3 C
Wk41 3 C
Wk42 3 C
Wk43 3 C
Wk44 3 C
Wk45 2 B
Wk46 2 B
Wk47 2 B
Wk48 2 B
Wk45 4 D
Wk46 4 D
Wk47 4 D
Wk48 4 D
Wk36 3 C
Wk37 3 C
Wk38 3 C
Wk39 3 C
Wk40 2 B
Wk41 2 B
Wk42 2 B
Wk43 2 B
Wk44 2 B
Wk40 4 D
Wk41 4 D
Wk42 4 D
Wk43 4 D
Wk44 4 D
Wk45 1 A
Wk46 1 A
Wk47 1 A
Wk48 1 A


regards
Sansk_23

 

[Pete_UK]

If you were looking for Wk36, as an example, what would you hope to
get?

Pete

 

[vezerid]

If I understand you correctly the table is in a single sheet but the
criteria values are in different sheets. Thus you need something like:

=MATCH(1,('table'!A2:A100='Sheet1'!K2)*('table'!B2:B100='Sheet2'!
B18)*('table'!C2:C100='Sheet3'!G9),0)

Here we assume that your data is in sheet table, a week number (e.g.
Wk39) is in Sheet1, K2, an area number is in Sheet2, B18 etc.

Notice that this is an *array* formula, thus you must commit with Shift
+Ctrl+Enter.

The above expression can be used inside an INDEX function to retrieve
a value in a column adjacent to your criteria columns, e.g. if 'table'!
D contains Amount and you want to find amount with the above
criteria:

=INDEX('table'!D2100,MATCH(...))

Again this must be array-entered.

Does this help?
Kostis Vezerides