How to apply a vlookup formula in a indirect formula?

[Acsadac]

Hi all,

I am currently doing a project at work, where I need som help:

Task: I have a data sheet, where I have a lot of unique keys, which I am to search for in an output sheet.

In the output-sheet the unique key that I am to search for is derived from two drop-down lists and one cell with static information. My problem is, that the information from the drop-down list is not applicable for the look-up in the data sheet. This means that I need to do a vlook-up into to find the text that correspondes to the text in the uniqe cells.

Could any one of you tell me, how I do a combination of a indirect formula and vlookup?

I have tried the following: =INDIRECT(A24;VLOOKUP("text";'DROP-DOWN LIST'!G3:H11;FALSE))

Thank you in advance!

 

[AliMass]

I don't follow your description. As a matter of principle, you can combine INDIRECT and VLOOKUP (although not quite the way you put it). Can you show an example of your data and how you want the result?

 

[Acsadac]

I don't follow your description. As a matter of principle, you can combine INDIRECT and VLOOKUP (although not quite the way you put it). Can you show an example of your data and how you want the result?

Thank you very much for you reply...

I have made a screenshot . I of my task.. I cannot upload a excel sheet

Skærmbillede 2015-06-11 kl. 21.17.08.png

Looking forward to your help.

 

[AliMass]

I see your screenshot, but ignored your massive formula. In Revenue and Sales Contributions (cells B10:C13), you want to bring in what is in columns J:K, correct?

I see that the cells A10:A13 would then connect to A3:B6 to know the two-character country code, and then the country code would link to, I assume, column H to get the right Revenue and Sales Contribution. Then you have a second parameter, which is D3:E6. In your example, it seems to match to A9.

One item I don't get is that in columns H and I, the items are not unique. I see DK and S combination in rows 3, 7, 11, and 15. Perhaps you meant to have the four countries with Shoes, and then the four countries with Jeans, etc.?

Assuming the items in columns H and I are unique (so column G is unique), put into B10 this formula (I haven't tested it, though, and if outside the US, you may need to change the comma to a semicolon): =VLOOKUP(VLOOKUP($A10,$A$3:$B$6,2,FALSE)&VLOOKUP($A$9,$D$3:$E$6,2,FALSE),$G$3:$K$18,4,FALSE)

Basically, I looked up the country code and added the clothing code. This put together matches column G, which the overall VLOOKUP will then grab the fourth column (column J). This should work if you copy to column C, but change the 4 toward the end to a 5.