lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
Can I do multiple column Vlookup. I searched the internet but most of examples are using Match-Index. I want to learn multiple Vlookup first then I will go to match-index. I am thinking of array function but do not know how to start
I have the table below. I want to do the following
Enter Name: John
Enter Item: Milk
Then excel will return 32
or excel will return 2 values the amount and date, so it will be 32 and mar
Is that possible? Thank you so much
<colgroup><col><col span="3"></colgroup><tbody>
</tbody>
Can I do multiple column Vlookup. I searched the internet but most of examples are using Match-Index. I want to learn multiple Vlookup first then I will go to match-index. I am thinking of array function but do not know how to start
I have the table below. I want to do the following
Enter Name: John
Enter Item: Milk
Then excel will return 32
or excel will return 2 values the amount and date, so it will be 32 and mar
Is that possible? Thank you so much
name | item | amount | month |
mary | milk | 59 | feb |
mary | water | 75 | jan |
mary | juice | 61 | feb |
john | milk | 32 | mar |
john | water | 1 | feb |
jon | juice | 73 | jan |
alex | milk | 60 | feb |
alex | water | 16 | mar |
alex | juice | 93 | feb |
linda | milk | 63 | jan |
linda | water | 19 | feb |
<colgroup><col><col span="3"></colgroup><tbody>
</tbody>