lookup not working

CommunityMember111277
CommunityMember111277
in Modeling

Hi,

 

Can anyone please explain why the below formula is not pulling any data? I wanted to fetch the details into LoS from SYS13 using LoS(numbers) as driver

 

LoS >> Line Item List(Length of service) 

 

I tried converting the LoS(Numbers) into Text & tried vlookup again but it didn't fetch any details

 

CommunityMember111277_2-1597951129050.png

 

CommunityMember111277_3-1597951210714.png

Thanks

 

Tagged:

Best Answer

  • jasonblinn
    jasonblinn
    Answer ✓

    @CommunityMember111277 

     

    I am not very clear on what you are trying to accomplish since the number that you are pulling in is the same as your list. It seems to me that you could just use your text line item and use the FindItem Equation to get it to your list instead of using the lookup.

     

    Jason

     

     

Answers

  • Ajinkya
    Ajinkya

    Hi @CommunityMember111277 ,

     

    Lookup will only work if the mapping is a list formatted line item, time period formatted item, or a property from the source. In your case, the mapping "LoS(Numbers)" line item needs to be list formatted and not text formatted as mentioned by you. 

    Hope this helps. Hit a like if it works for you.

     

    Regards,

    Ajinkya

Categories