Please see attached
I need a look up and return in C5,…. It need took at A5 on Sheet 2 and return Multiple shipping numbers in one columns from column B
Expected data is in yellow
Paul
Please see attached
I need a look up and return in C5,…. It need took at A5 on Sheet 2 and return Multiple shipping numbers in one columns from column B
Expected data is in yellow
Paul
How many lots could be? If it 2,3...
For max 3 items array formula
Formula:Please Login or Register to view this content.
Last edited by BMV; 01-15-2020 at 07:25 AM.
maximum would be 3
how do iappl this to the sheet ?, keeps saying error
I thing error was because different separator (; and ,) . Look an the file I attached to #2
I have to use 3rd condition Load Truck, and it is array formula finish must be Ctrl+Shift+Enter!
Last edited by BMV; 01-15-2020 at 07:29 AM.
Hi,
Using Power Query
then
=VLOOKUP(A5,CHOOSE({1,2},'Power Query'!A:A,'Power Query'!B:B),2,FALSE)
Christopher Yap
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks