Forum Discussion
Solved
Vlookup duplicate with aproximate values
Hello, I have a table with KM and SB and I need to know the subdivision, according to another table Trem KM SB H17 170,1 LEB D22 133,6 LAR W03 301,302 ZSN H21 81,52...
I can't relate the 2 tables, because there are no columns with unique values.
The KM of the first table must be >= KMI and <KMF from the second table
You can create a column using IF or Lookupvalue statements too.
I would not do it justice to list the options here but see
- Zubair_Muhammad
Community Champion
You can use this column in Table 1 to get all equipments in Table 2 that fall in the range
Column = CONCATENATEX ( CALCULATETABLE ( VALUES ( Table2[Equipamento] ), FILTER ( Table2, Table1[KM] >= [KMI] && Table1[KM] <= [KMF] ) ), [Equipamento], ", " )or you can use this column if you want any of the matching equipments
Column 2 = CALCULATETABLE ( FIRSTNONBLANK ( Table2[Equipamento], 1 ), FILTER ( Table2, Table1[KM] >= [KMI] && Table1[KM] <= [KMF] ) )- Zubair_Muhammad
This has been very helpfull.
But it's missing the SB as parameter
The "trem" H99 "SB" NOR should have the "Equipamento" 21/083220-084200tg but it's bringing 77/300500300745cv instead.
SB it's the location and must the same in both tables.
How can I look between de Km's and on the exact location?