Hi Guys,

One of my colleagues is trying to programme a macro to do a vlookup.

The problem is that the source data doesn't always have the same column headings in the same columns.

I have looked at the below:

=VLOOKUP(K5,VLOOKUP(MATCH("orange",A2:F2,0),P:Q,2,FALSE)&":H",2,FALSE)
This is just test data. in P:Q I have numbers 1 through 10 in P and then A,B,C etc in Q.

This mostly works, but the resulting formula is 
=vlookup(6,"E:H",2,false)
This is the end foruma that I'm looking for, but I think that the " around the column range E:H is what is returning a #Value error.

Can someone look at this and advise please?