navinrb
Board Regular
- Joined
- Jun 9, 2020
- Messages
- 82
- Office Version
- 2019
- Platform
- Windows
- Mobile
- Web
Suppose i have lookup values in sheet 1as
Apple,orange,banana
Carrot, watermelon
Apricot, grapes
I want to lookup above fruits in following table in sheet 2
Apple,orange,banana
Carrot, watermelon
Apricot, grapes
I want to lookup above fruits in following table in sheet 2
Fruits. Qty. . Price Apple. Banana. Orange. Watermelon. Grapes Apricot Carrot. |
Last edited: