var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Vlookup fuction
is anything wrong with this function
AC6 is the unique number relative to both tables.
K is the column of the unique number
L is the Number I am trying to find
12 is = to L in the alphabet.
Just looking at it, there's nothing wrong with it. Putting it in your spreeadsheet example from your other example it worked fine.
What error are you getting?
If you change the Function to this
this should work for you
I just replaced 12 with 2
Although L is the 12 letter of the alphabet you are only looking up 2
Columns K and L so the VLOOKUP you suggested was trying to find the
12th Column in the range K:L which dosen't Exist hence #REF! is returned.
Hope this helps
Is it possible to look up two seperate columns while using a v lookup?
Ex: The data is in Coloumn A and D.
I think not.
You might have to do nested INDEX/MATCH functions to accomplish this.
I like sumproduct - it's easier to understand than the index/match