Thread: Is V-Lookup suitable

I just can't get it to work. It always gives N/A. The help file says:

"Lookup_value is the value to be found in the first column of the array. Lookup_value can be a value, a reference, or a text string"

Ok, so a column containing values that will be used to reference other columns...

"Table_array is the table of information in which data is looked up. Use a reference to a range or a range name, such as Database or List"

Array?

(array: Used to build single formulas that produce multiple results or that operate on a group of arguments that are arranged in rows and columns. An array range shares a common formula; an array constant is a group of constants used as an argument.)

But whether the array could also just be categorical variables? Because in my dataset one variable is not the 'function' of the other in a mathematical sense.

I have two columns B and C that contain data to be referenced by A. Essentially:

A is related to B
B is related to C

I want the formula to lookup each value in A, find a match in B, then give me the value that appears beside B in C. Is this possible with V-Lookup, or should I be using something else?

Thanks in advance.

confused, it is better that you give a sample file

thanks for your reply. i tried using the examples you gave but it produced #VALUE

i have attached a spreadsheet with the data for you to take a look at.

cheers

Good man! That worked perfectly!
Thanks for the link too
Cheers