Hello
Newbie so please bear with.
So, I want to pull a Value from a table using the lookup based on data in column A of a new sheet. I need to use the header rows of the table to find my Value as the number of columns will differ but the row header will not change. For example
<tbody>
</tbody>
I need to get the amount under Col2, with Basic as the name, by using the Unique Ref. A vlookup would work fine but if I want to paste new data over this, the value I need might be in Col3 but the coulmn Header, Basic, will still be the same.
Any insight will be greatly appreciated.
Newbie so please bear with.
So, I want to pull a Value from a table using the lookup based on data in column A of a new sheet. I need to use the header rows of the table to find my Value as the number of columns will differ but the row header will not change. For example
Unique Ref | Col1 | Col2 | Col3 | Col4 |
ABCD | 100 | 200 | 300 | 400 |
EFGH | 200 | 300 | 400 | 500 |
IJKL | 300 | 400 | 500 | 600 |
MNOP | 400 | 500 | 600 | 700 |
<tbody>
</tbody>
I need to get the amount under Col2, with Basic as the name, by using the Unique Ref. A vlookup would work fine but if I want to paste new data over this, the value I need might be in Col3 but the coulmn Header, Basic, will still be the same.
Any insight will be greatly appreciated.