E
EXCELlently Confused
I'm trying to use a part number from one list to find the
same part number in another list in order to get the
updated value of on-hand inventory. I know this can be
done with an excel vlookup but the only problem is that
there are other criteria that need to be factored in when
traversing the lists because part numbers appear multiple
times depending on which logical storage location they are
sitting in and their receipt date. Please advise if there
is a way to use the vlookup function with multiple values
or nested vlookups in order to accomplish this query.
Thanks!
same part number in another list in order to get the
updated value of on-hand inventory. I know this can be
done with an excel vlookup but the only problem is that
there are other criteria that need to be factored in when
traversing the lists because part numbers appear multiple
times depending on which logical storage location they are
sitting in and their receipt date. Please advise if there
is a way to use the vlookup function with multiple values
or nested vlookups in order to accomplish this query.
Thanks!