Excel formulae help please,

  Taurus 15:36 05 Apr 2014
Locked
Answered

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 2014

INDEX MATCH

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

  Taurus 19:07 05 Apr 2014
Answer

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.

Dave

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

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

What went wrong at the Designs of the Year 2017

iPhone X news: Release date, price, new features & specs

Comment regarder des séries et talk-shows américains en France ?