Excel formulae help please,

  Taurus 15:36 05 Apr 14
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 14

INDEX MATCH

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

  Taurus 19:07 05 Apr 14
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.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

This abstract video touches on division in our technologic world

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…