Forum Discussion

drallam's avatar
drallam
Icon for Helper II rankHelper II
9 years ago
Solved

LOOKUPVALUE ERROR

Hi I'm trying to look up a region(text type) and assocaite zipcode to it, in Table 1 from Table 2 where both zipcode(whole number type) and region(text type) are present. Can anyone please help me...
  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    Hi drallam,


    You can create a calculated column using the formula, please try and check if it returns expected result.

    associate zipcode=LOOKUPVALUE(Table[zipcode],Table[region],"the region wanted")


    If not, what's your error message? And what does your resource table look like? Could you please share your sample table or details for further analysis?

    Best Regards,
    Angelia

v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi drallam,


You can create a calculated column using the formula, please try and check if it returns expected result.

associate zipcode=LOOKUPVALUE(Table[zipcode],Table[region],"the region wanted")


If not, what's your error message? And what does your resource table look like? Could you please share your sample table or details for further analysis?

Best Regards,
Angelia

  • drallam's avatar
    drallam
    Icon for Helper II rankHelper II
    9 years ago

    Angelia!

     

    thank you. It worked. I was thinking to enter a value in the <search_value> field. I specified the column and worked perfect.

     

    I also figured out a workaround until in this mean time. I used RELATED function and specified that table. It pulled in the zipcodes i needed.

     

    Thanks for your input!