SamanthaRaggett
New Member
- Joined
- Aug 23, 2021
- Messages
- 5
- Office Version
- 365
- Platform
- Windows
Hi
I am using the INDEX, INT and column to get my formula to move every 3 column when copying across.
I have used it before but this time i need to merge vlookup with it and i have errors popping up.
I am using this formula below to search for a value on a different sheet and then return the answer. 1) how do i get the vlookup to move to the next column when i move across? 2) how do i fix this formula so that i dont get REF! when i try to copy it across all the columns?
=INDEX(VLOOKUP($A$3,Table1,12,FALSE),INT((COLUMNS($J75:J75)-1)/3)+1)
I can email the doc if that would be easier.
Thanks in advance.
I am using the INDEX, INT and column to get my formula to move every 3 column when copying across.
I have used it before but this time i need to merge vlookup with it and i have errors popping up.
I am using this formula below to search for a value on a different sheet and then return the answer. 1) how do i get the vlookup to move to the next column when i move across? 2) how do i fix this formula so that i dont get REF! when i try to copy it across all the columns?
=INDEX(VLOOKUP($A$3,Table1,12,FALSE),INT((COLUMNS($J75:J75)-1)/3)+1)
I can email the doc if that would be easier.
Thanks in advance.