Formula to look for value into several columns.

Hello to all -

I am trying to perform a VLOOKUP in the following table:

VLookup.png

In cell F2, I select the week (i.e. Week 9). In F3, I need formula that returns the 1st value the column Week 9 (7,000). In F4 the 2nd value (15,500). In F5 the 3rd value (2,500) and so on.

If I change the Week, returns the corresponding values of the corresponding column.

I will appreciate very much this big favor. Due to Security Settings, please no VBA Code.

Best regards to all and please have a great day and an excellent weekend.
(Saludos cordiales a todos y que tengan un gran día y un excelente fin de semana).

SamCV.
Matamoros, Mexico.

Hello Alkey -

Thank you for the prompt answer!!!

The formula worked very well. I modified it a little bit and added a help column to indicate the lookup row. In my case, column A is my help column.

Formula:

Please Login or Register  to view this content.

VLookup.png

I appreciate very much you help. I had added reputation to you and will mark this thread as Solve.

The best of days to you.

SamCV.

Originally Posted by SamCV

Hello Alkey -

Thank you for the prompt answer!!!

The formula worked very well. I modified it a little bit and added a help column to indicate the lookup row. In my case, column A is my help column.

Formula:

Please Login or Register  to view this content.

Attachment 304482

I appreciate very much you help. I had added reputation to you and will mark this thread as Solve.

The best of days to you.

SamCV.

It was not necessary an additional column. You could use this formula:

= HLOOKUP($F$2,$A$2:$E$10,ROW()-1,0)