Hi All,
I'm looking to do an H_Lookup but every column is split in 3 sub -columns.
So lookup value is a merged (3) cell , I would like to do a separate H_lookup to search for the 3 sub-values.
Example in attached excel file.
thanks in advance.
Hi All,
I'm looking to do an H_Lookup but every column is split in 3 sub -columns.
So lookup value is a merged (3) cell , I would like to do a separate H_lookup to search for the 3 sub-values.
Example in attached excel file.
thanks in advance.
DON'T MERGE CELLS!
It's a very bad habit, and can complicate many things, so get out of it. Don't put form before function.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hi AliGW,
I know merging cells isn't a very good option...
But unfortunately this file requires it, do you have an option to help me out?
thx
Please try at H3
=IF($G3="","",INDEX($R2:$W10,$G3,MATCH($H$1,$R$1:$W$1,)+COLUMNS($H3:H3)-1))
Thanks! works great.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks