Is the formula you posted in Response # 8 related to the one you originally posted or is it a different (but similar) question?
In your OP you said "I want the data from the next cell to also be shown in the same cell" and later posted an updated example using H10 & I10. In other words H10 and the next cell.
In Response # 8, your formula is using HLOOKUP to look up values in 2 non-contiguous cells, C10 & H10.
Is the next cell question no longer an issue or by next cell did you mean another cell?
In addition, all of the formulae you posted are looking up values in the same file and same sheet as the formulae reside in. Can we assume that these are just examples and that you really have 2 different files? If not, I'm not sure why you would use HLOOKUP to look up in a cell that resides in the lookup_array on the same sheet.
In other words, looking up C10 and H10 in A10:Z10 of the same sheet will simply return the values in C10 and H10, so you could just use =H10 & " - " & C10.
Please clear up these 2 points of confusion for me.