Forum Discussion
Helper IIIlookup within the range
Hi ,
I have field called diameter which I have to compare with a range to bring a value.
e.g.
Reference Table:
I have the reference column in the comparing table except the diameter is in one field
e.g. Comparing Table
So my issue is I can lookup first 3 columns from each table but the diameter in the reference is within the range 1 to 10 or 1 to 1000 which I'm unable to lookup to bring the matching 'Material Asset Category' field.
Any solution for the easiest way is greatly appreciated.
Kind Regards,
Chiru
3 Replies
chiru5262amitchandak AlexisOlson Greg_Deckler ,any suggestions please
- AllisonKennedy
Community Champion
chiru5262 I think this blog should help detail what you're trying to do: https://excelwithallison.blogspot.com/2020/06/dax-approximate-lookup.html
Make sure your two tables aren't related.
v-henryk-mstfCommunity Support
Hi chiru5262 ,
Seems to not quite understand your needs, can you provide more information or test data, so that I can answer for you as soon as possible.
Best Regards,
Henry
