Forum Discussion
Stuznet
Helper V
Helper VDynamic lookupvalue or Calculated column
Hi guys,
I’m having trouble getting this.
Here is the situation,
Column A contains Blank and values , Column B is an IDs field which has no Blanks.
I’m trying to do a lookup.
So basically if Column A = Blank() search Column B for the ID return Column A if is match.
What is the best solution here? Create a new lookup table? Or new column? Could you please provide me direction or instruction?
Thank you
I’m having trouble getting this.
Here is the situation,
Column A contains Blank and values , Column B is an IDs field which has no Blanks.
I’m trying to do a lookup.
So basically if Column A = Blank() search Column B for the ID return Column A if is match.
What is the best solution here? Create a new lookup table? Or new column? Could you please provide me direction or instruction?
Thank you
2 Replies
- PattemManohar
Community Champion
Stuznet It will be better to post some sample data along with expected output, which will be really helpful to provide an accurate solution.
v-piga-msftResident Rockstar
Hi Stuznet,
I'm still a little confused about your scenario.
If it is convenient, could you share some data sample which could reproduce your scenario and your desired output so that we could help further on it?
Best Regards,
Cherry
