VBABEGINER
Well-known Member
- Joined
- Jun 15, 2011
- Messages
- 1,232
hi all,
I need formula, where lookup values are in two different columns, and with combination of these 2 values I want to find an answer....
I use this formula, but these is something wrong..
I need formula, where lookup values are in two different columns, and with combination of these 2 values I want to find an answer....
Column A Column B Column C Column D Column E E L p q r 30 L1 10 40 60 31 L2 20 50 70 31 L1 30 60 80 Value to find Answer Require.. 31 L1 80
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
I use this formula, but these is something wrong..
=VLOOKUP(AND(A4,B4),A2:E4,3,FALSE)