FIND THE LOWEST NUMBER IN AN ARRAY
Posted by Lars on June 12, 2001 11:25 AM
Hey Mark if you are still there I need your help again!
Here is my data:
column A B C
ATLFLLDLQ 1 50 ATLFLLUSQ
ATLFLLUAK 4 80
ATLFLLUAK 4 85
ATLFLLUSQ 2 75
ANCFLLHPV 1 50
ANCFLLNWT 2 75
Can I lookup the ATLFLLUSQ on the right column above (which is on another sheet) and look it up in a range (represented by the first three columns above)and find all the ones that start with the FIRST 6 DIGITS ATLFLL (ignoring the last three digits) in the left column and within all the ATLFLL's that are found, find the one that has number 1 (column B)next to it and put the last character in a cell and also put the fare (column c above)in another cell and the carrier (7 and 8th digit) in another cell?
For example find ATLFLLUSQ (in column A look only for ATLFLL that has the 1 next to it and return in three different cells the carrier (7th & 8th character in the string) the last character and the fare (column C)- the answer would be DL Q 50.
Is this possible?