Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I cannot find a way to return (for instance) the distance in the 3rd column
of a distance table, for a whole series of "From" - "To" iternies in another tabel. These "from"and "to" fields are text-values in 2 different columns. For each combination, I want to test whether there is a distance in the table for this iterny, and if so, return that distance. The VLookup can only check 1 criteria (or at least I can..) and there might also be multiple (but unknown numbers) destinations from 1 origin. I thought of making one text-string out of the "to" and "from" and VLookup that string, but I imagine there is a more elegant solution to this! Regards and thanks in advance! Max |