vlookup with different col_index_num
Yes, have a look at Jacob's solution.
I can amend your formula if you post it here, and if you can give me
details of the cell references used for your table.
Pete
On Aug 17, 10:52*am, ArcticWolf
wrote:
Thanks for the quick response Pete. *Can I be a pain and ask you to amend my
original vlookup as I'm having difficulty placing the MATCH function into it
without getting an error. *I'm trying to replace the "3" with the match
function, is this correct?
Thanks,
AW
"Pete_UK" wrote:
You could use MATCH on the column headings to return the column
number, so instead of your 3 you would have something like:
MATCH(A$1:D$1,"heading",0)
If columns are inserted between A and D the formula will automatically
adjust.
Hope this helps.
Pete
On Aug 17, 9:17 am, ArcticWolf
wrote:
Hi,
I have a vlookup which returns the value from a table called data. *The
column I want from the table is column 3, so =vlookup(a1,data,3,false)
However, the table will expand over the coming months with new columns
inserted before the 3rd column in the data table. *This will make my lookup
incorrect as the data I want is not in column 3 (but in 4 or 5 etc...) *
The column heading will always remain the same (if that is of use?), so how
can I get Excel to find the column I need as opposed to using the
col_index_num?
TIA,
AW- Hide quoted text -
- Show quoted text -
|