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...
Zubair_Muhammad
Community Champion
Community Champion
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?