Multiple LOOK UPs

[BPM Aditya]

I have excel sheets. Normally when we Vlook up, we use the following formula
VLOOKUP(A4,'HCV TL'!A3:R12,2,FALSE),
where
1. A4 is the look up value in 1st sheet,
2. 'HCV TL'!A3:R12' is the look up range in 2nd sheet
3. 2 is the column number from which the value is to be returned
4. FALSE is for exact match.

Now I want to look up 2 values at a time (For e.g along with A4, I walso want to look up another value (say B4)), then I want a value to be returned from 2nd sheet from the corresponding row or column by satisfying the 2 conditions.

Please suggest a formula.

 

[jimrward]

you could create a helper column which joins A4 and B4 and use this in the lookup

 

[BPM Aditya]

Could you elaborate please....

 

[Yahya]

could you post small sample for your data

 

[Aladin Akyurek]

I have excel sheets. Normally when we Vlook up, we use the following formula
VLOOKUP(A4,'HCV TL'!A3:R12,2,FALSE),
where
1. A4 is the look up value in 1st sheet,
2. 'HCV TL'!A3:R12' is the look up range in 2nd sheet
3. 2 is the column number from which the value is to be returned
4. FALSE is for exact match.

Now I want to look up 2 values at a time (For e.g along with A4, I walso want to look up another value (say B4)), then I want a value to be returned from 2nd sheet from the corresponding row or column by satisfying the 2 conditions.

Please suggest a formula.

A4 is matched against 'HCV TL'!A3:A12. Care also to specify the match range for B4? And what is the result range, that is, the range from which a result must be returned?

Or try adapt the following generic formula:

=INDEX(ResultRange,MATCH(1,IF(MatchRange1=A4,IF(MatchRange2=B4,1)),0))

which must be confirmed with control+shift+enter, not just enter.