Help required with Nested VLookup function

[scott-atkinson]

Could somebody be of assistance please.

I am trying to put together a nested Vlookup Function, example below;

=VLOOKUP($B$3,Data,(MATCH(A23,Row1,0)))

I am trying to do the following, I have a spreadsheet layed out in the following format;

Row - Date, Jan05, Feb05 etc

Col - Product code.

I am trying to bring data into a spreadsheet using the following format;

=VLOOKUP(Product Code,Data,(MATCH(Date,Row1,0)))

The output in some cases does not return any data when there is data to return, and in some cases it returns the wrong data from a product code that seems to be completely unrelated!

My product codes are made up of a combination of Letters/Numbers, and just Numbers, I have formatted both data sets so are reading the same.

Any body got any ideas as to where I am going wrong.

 

[Katy]

Hi. I don't think you can nest in this way with a Vlookup as you are trying to achieve two different things. The vlookup will return data based on a common field and match will give you data which is in the same position on a spreadsheet. What are you trying to do?

 

[shades]

Howdy. Can you provide a small sample of how your data is arranged, and then how you want the output? It might be that INDEX/MATCH combination will be better.
________
VAAAPP VAPORIZER

 

[unmarkedhelicopter]

Or sumproduct match ... or an array

 

[DanG]

How about this...
=INDEX($C$1:$C$4,MATCH(1,IF($A$1:$A$4="John",IF($B$1:$B$4="Green",1)),0))

It is an array formula so do not forget to cse on it.

 

[unmarkedhelicopter]

Data would be good, along with an example of a question and it's answer.

 

[scott-atkinson]

I have managed to get my nested function to work, for some reason it was working ok when when the majority of the Lookup was text, and not when it was numeral, not sure why, though.

I have simply changed the lookup to the product description rather thant the product code.

Thanks for your suggestions anyway.