Thread: Complex 3-inputs lookup table
View Single Post
 
Old 12-06-2016, 03:12 PM
Mr.Onion Mr.Onion is offline Windows 10 Office 2010 64bit
Novice
  
Join Date: Dec 2016
Posts: 3
Mr.Onion is on a distinguished road
Default
Thank you for your response. I've managed to get it to works with the INDIRECT function(which looks much more convoluted and confusing). I didn't know it had an OFFSET function and did around about way with COLUMN and ROW which make it looks like a nightmare.
Thank you again.
Reply With Quote