Look up using values from a multi sheet excel document

[martin_hamilton]

Hi

I have an excel sheet with multiple tabs which have system values to descriptions tables within it.

I wish to use values from each tab in a look up against loaded tables.

When I load the data it places it all within 1 table in qlikview but I want to have it in multiple tables as values might be the same in each tab but mean differing things when looking it up as a reference.

So when I reference the Value in my look up it doesnt work. So the question is:

Is it possible to create differing tables from a single multi sheet excel document and if not how do I reference in the look up.

Attached is what I have set up currently.

[Anil_Babu_Samineni · Accepted solution]

I've attached good example, Please have a look

[martin_hamilton]

Hi Anil

Not exactly what I was looking for but inspired me to make a slight change and it worked perfectly.

Many Thanks

Martin

[Anil_Babu_Samineni]

Glad to help to resolve out