How do I make it so that the # of rows over increases by 1 everytime I move over one to the right? For example, take in cell B2 I have vlookup(B1,some range,3,0) and in B3 I want vlookup(B1,some range,4,0) and in B4 I want vlookup(B1,some range,5,0), etc. How do I set up my formula so that the col index number increases as I move right?
| +415 | Evercore Intern Seizure | 63 | 5h |
| +128 | UBS IB Americas has failed, now behind Santander and Stiffel | 34 | 11h |
| +97 | Sent my Claude prompt to 200+ Teams chat. MD wants to see me Monday. | 34 | 2h |
| +79 | deleted deleted deleted deleted deleted | 44 | 15h |
| +65 | How do I understand vs. just memorizing? | 11 | 1d |
| +57 | Some banks are overrated as fuck | 17 | 1h |
| +48 | Associate & Above IB exits | 18 | 1d |
| +47 | The good and bad with Wells Fargo | 17 | 54m |
| +42 | Tech to IB Pivot | 22 | 5h |
| +36 | Incoming IB Analyst: Best Ways to Prepare? | 13 | 23h |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Make the numbers cell references to cells that increase.
So say in A1-A25 I have the numbers 1,2,3,4, etc till 25. Have my vlookup(reference,range,vlookup of 1,2,3,4 etc,0) like that?
=vlookup(reference, range,A1,0)
When you copy that across it will automatically become =vlookup(reference, range,A2,0)
How do I make it so that the # of rows over increases by 1 everytime I move over one to the right? For example, take in cell B2 I have vlookup(B1,some range,3,0) and in B3 I want vlookup(B1,some range,4,0) and in B4 I want vlookup(B1,some range,5,0), etc. How do I set up my formula so that the col index number increases as I move right?
Reference the row. try the following formula for cell B1, B2, B3, B4, b5 in a blank worksheet.
=Row(A15) =Row(A16) =Row(A17) =Row(A18) =Row(A19)
Just make the vlookup a function of the that. So you just need to figure out what the offset is betweem these values.
For example in your above example B2's lookup row/col is 3, while B4's is 5. So obviously your lookup row/col is Row(Range)+1. You would change your above formula to:
B2 = vlookup(B1,some range,(Row(B2))+1,0) B4 = vlookup(B1,some range,(Row(B4))+1,0)
B2 = vlookup(B1,some range,(Row(B2)+1),0) B4 = vlookup(B1,some range,(Row(B4)+1),0)
Suscipit incidunt et veritatis iusto aperiam eos ea. Doloribus voluptatibus cumque recusandae et quis sunt est. Repellat perferendis perferendis beatae et. Laborum autem qui modi doloribus officiis vel. Ad laboriosam eum ab earum dolore facere corrupti porro. Dolorem neque temporibus nisi aspernatur vero omnis facilis non.
Sit aperiam nostrum impedit dolore est at. Voluptatem facilis laudantium quas laudantium et nulla omnis. Corrupti et sequi nihil ipsam.
Maxime expedita sequi quibusdam aut in. Quia laboriosam commodi dolores repellendus occaecati qui quo. Facere quis repellat et ab beatae est ex. Ut occaecati eos numquam sed perspiciatis. Quibusdam ut sed nostrum quam laboriosam rerum aliquid nemo. Doloremque odit sint et et. Non mollitia suscipit ex in quibusdam sit.
Sequi numquam odio consequatur quos. Autem repellat deserunt laborum sequi voluptas architecto. Quam quia aut quibusdam hic accusamus quisquam. Nostrum iusto suscipit quia illum modi. Eligendi esse consequatur harum aut veritatis voluptate.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...