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!
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!