ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   VLOOKUP with OFFSET (https://www.excelbanter.com/excel-worksheet-functions/101871-vlookup-offset.html)

Robert

VLOOKUP with OFFSET
 
I have data in the following manner. The main
item is in col A, the components in col B: col E.
I am very familiar with VLOOKUP, how can I (if
possible) use this function to return the components
in H2:J6 if for example BUS is entered in G1.
The number of components may vary, 5 or 6
but if this will be a problem, can be standardised

A B C D
1 CAR TAX 30 300
2 TYRES 5 200
3 BATT 1 70
4 LEATHER 1 500
5 ALARM 1 1000
6 BUS AIRCON 1 5000
7 TAX 30 1000
8 VIDEO 1 800
9 SEATS 20 4000

Thank you,
Robert



All times are GMT +1. The time now is 11:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com