0

Im currently working on an excel sheet for my company, the model im being tasked to work in lookes like this: enter image description here

Im trying to make a match index from using col E and col G to fill out col H, my idea is to use F as a hidden helper col so im typing in one sample ID in col E and then 7 rows in col F will fill out with the same sample ID and then the match index would be kinda straight forward, I have a vague idea that using OFFSET is the way to go but i cannot get it working... Does anyone have an idea of how to get the OFFSET formular to work or maybe another idea as to how i can get this working?

Mikkel Astrup
  • 405
  • 6
  • 18
  • Have a look at this : https://stackoverflow.com/a/28180906/4961700 – Solar Mike Feb 11 '19 at 09:46
  • I can't see the image from my work, but looks like a job for `INDEX()`. Also keep in mind, if you have lots of data, that `OFFSET()` is *volatile* while `INDEX()` is not. This can make a big difference. – iDevlop Feb 11 '19 at 09:48
  • @SolarMike your link is about Google spreadsheet. AFAIK `UNIQUE()` does not exist in Excel. – iDevlop Feb 11 '19 at 09:50
  • @PatrickHonorez true, oops... But there are **many** other Q and A showing the use of index with match... – Solar Mike Feb 11 '19 at 09:52
  • Try this one : https://stackoverflow.com/a/46886998/4961700 – Solar Mike Feb 11 '19 at 09:54

0 Answers0