![]() |
|
#1
|
|||
|
|||
![]() Hello, I've works with excel for a lot of things and this is just a side project for me. I'm having trouble getting it to work and I would like to ask you guys to help me if you guys have time to spare. Since I don't know how to do Macro or VBA, I'm looking for just a functions-only solution to this. I've included the problem in the excel file. Please feel free to ask any question for any clarification. Thank you. |
#2
|
||||
|
||||
![]()
In H5, J5, H7 & J7, use:
=OFFSET($A$13,MATCH($F5,$A$13:$A$22,0)-1,MATCH(J$2,$A$13:$Q$13,0)-1)
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
![]()
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. |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
LOOKUP - Complex lookup with 2 lookups in 1 cell | sglandon | Excel | 6 | 05-05-2016 09:44 AM |
![]() |
Andrew H | Word Tables | 2 | 11-24-2015 07:41 PM |
![]() |
ElfegoBaca | Word | 1 | 10-15-2014 06:34 PM |
![]() |
Cosmo | Word Tables | 12 | 06-30-2014 05:28 PM |
Help with Complex Table Creation | saquib | Word | 0 | 02-12-2013 06:28 AM |