Excel formulae help please,

  Taurus 15:36 05 Apr 14

Hi everyone, I have a little brain freeze that I'm hoping you can help me with. For information I'm using MS Office 2014.

I have a grid of fixed data covering 6 columns (I-N) and 98 rows (4-102 (I plan to hide this when the sheet is finished as it is immutable). The first column, (I) are numbers, the other 5 rows are a mixture of numbers and text. I have a similar empty grid of 6 columns (B-G) and of potentially infinite rows. I want to be able to enter a number in the first column of the empty grid and have the spreadsheet fill in the other 5 rows with the data corresponding to the relevant number in the data grid.

Any help you can give me will be very much appreciated

  Zak 17:25 05 Apr 14


may be a useful solutioon in this instance 1]: [click here

  Taurus 19:07 05 Apr 14

Thanks for responding Zak, got a headache just glancing at it, but It looks promising and I'll have a proper look after I've eaten, might make some sense of it then.

Cheers, will get back and let you know how it went.


This thread is now locked and can not be replied to.

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation technologies coming to Siggraph 2017

iPad Pro 12.9 vs Surface Pro 5