LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
John F
 
Posts: n/a
Default Formula to extract pricing from a chart

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with xlusrgal.xls file Alfred S C Lee Charts and Charting in Excel 2 December 29th 04 05:54 PM
Impedding/Overlaying Charts Phil Hageman Charts and Charting in Excel 4 December 17th 04 07:25 PM
create a chart with a formula anon Charts and Charting in Excel 1 December 15th 04 08:55 PM
pivot table multi line chart souris Charts and Charting in Excel 2 December 7th 04 03:56 AM
Formula to Extract Data from a Table Macshots Excel Worksheet Functions 2 November 5th 04 06:35 AM


All times are GMT +1. The time now is 10:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"