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...
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
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?
