How to show Horizental range in drop down list using formula?

[Ariful Islam]

I don't know if my concept is correct or if it will be possible.
My formula looks correct, but the drop down list looks wrong.
How do I show a horizontal range in drop down list in Excel?
I have used this formula below...

Please Login or Register  to view this content.

Someone help me please.

[AliGW]

Try this:

=TRANSPOSE(XLOOKUP(N2&O2,$A$2:$A$14&$B$2:$B$14,$C$2:$D$14):XLOOKUP(N2&O2,$A$2:$A$14&$B$2:$B$14,$C$2:$D$14,,,-1))

[Pete_UK]

Using Name Manager on the Formulas tab you can set the name List2 to refer to:

=Sheet1!$F$2:$L$2

I'm not sure why you are trying to use XLOOKUP to define the range.

Hope this helps.

Pete

[Ariful Islam]

Yet showing error.

[AliGW]

Whom are you addressing? Me or Pete?

Mine works in your sample file.

[Ariful Islam]

The drop down list does not accept this formula.

Please Login or Register  to view this content.

[AliGW]

No, it won't. You need to define a named range for the place where you have the list. You should know this from what you've already done in that workbook. However, the formula DOES return a vertical list.

[Ariful Islam]

Still error..

[Ariful Islam]

However i got this solution by following formula..

Please Login or Register  to view this content.

You are all very sincere and helpful. Thank you very much.

[AliGW]

If you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.