Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Chart is on my L-Ups Work Sheet.
Chart consists of (9) rows (Showing Lengths down left side) and (7) Columns (Showing unit codes across Top) Whatever the Unit Code is in cell E5 of my active sheet, to trigger a "match" to the Unit Code on my L-Ups Work Sheet - Then extract (copy) the pricing under that code and insert into cells J6 thru J14 If the best way is to use a nested Look-up, then I need to know if there is a function that allows the use of the chart, OR do I have to split the chart up into 7 pieces of 9 rows. Somehow I have a feeling I'm missing something obvious, but I just can't get my head around this one. (not the first time, though) -- John F. Scholten |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Problem with xlusrgal.xls file | Charts and Charting in Excel | |||
Impedding/Overlaying Charts | Charts and Charting in Excel | |||
create a chart with a formula | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel | |||
Formula to Extract Data from a Table | Excel Worksheet Functions |