PDA

View Full Version : Excel 97 LOOKUP



07-02-2000, 09:03 AM
Working in Excel 97, I have a problem involving LOOKUP.

I have a chart, with a table in Columns A thru E,covering lines 1 thru 10.

In Cell G1 I have a number corresponding to the column 1=B,2=C, etc. In H1 I have a number corresponding to the vertical, 1=L2, 2=L3, etc.

In Cell I1 I need to produce the corresponding chart value, which is numeric in nature.


Can you assist at all?

Regards
Graham Bockett
gbockett@paradise.net.nz