col_index_num

Hi I have a peculiar problem while using VLOOKUP The issue at hand is this 1)There are two sheets say Sheet 1 and Sheet 2 2)Now I have to look up variable in Row A2 in Sheet 1 for a given date in a specified range in Sheet 2. 3)So I do a this action for eg vlookup($A1...

Hi everyone! My formula requires a VLOOKUP function that I think will involve the use of several nested indirect functions. Let's call my current worksheet Test1. Here's what I need: =VLOOKUP(lookup_value, table_array, col_index_num, FALSE) 1. For my table_array, I need the range $A:$Z in...

Hi there, I am trying to figure out how to perform a VLOOKUP and return a concatenated result from multiple columns on the matched row. Below is how I want the data to end up looking: Result Worksheet <tbody> A B C 1 Full Name Phone Address 2 Joe Smith 1234 123 Gumdrop Lane, Gummie...

Hi All, I am trying to create a dynamic col_index_num for a sum vlookup array I am using, but without much luck. I was originally using the formula: {=SUM(VLOOKUP($B5,'Total Sales (Endo)'!$B$10:$AB$17,{3,5,7,9,11,13},0))} Which works perfectly. However, I would like the {3,5,7,9,11,13} to...

Ok, so I'm using a simple VLOOKUP() to fetch some user data from an db sheet that has all info about the users. For the col_index_num parameter I use {2,3,5,9}. Now I'd like to have all the data returned in separate cells in my working sheet. Would that be possible somehow? (Instead of having...

I am hoping someone will be able to help, i am trying to get a VLOOKUP to work over a number of different columns. An example the problem: Sheet1 A B 1 10 2 20 3 30 4 40 5 50 Sheet1 is the sheet i want to lookup the values and i want to place the results into column B Sheet2...