VLOOKUP with multiple results

Rodrigo Colsa

Hello!

I have two sheets and I'm trying to find a way to bring to a order tracking sheet (2nd image) different information about shipping cost (1st image) but my vlookup brings juts the first result. can anyone help me understanding if there is another function?

Shipment data sheet:

Order tracking sheet:

Thank you in advance for your help!

Andrée Starå

Hi @Rodrigo Colsa

I hope you're well and safe!

Can you paste the formula you're using?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Rodrigo Colsa

Thank you for answering!

=VLOOKUP([Consumer Name]@row, {SHIPMENTS Range Cost}, 11, false)

Andrée Starå

@Rodrigo Colsa

Happy to help!

Do you want to match the Consumer Name and the date?

Rodrigo Colsa

Hello Andree,

I want to bring the Shipping Cost from the Shipment data sheet (1st image) to the Order traking sheet (2nd image) Those are orders from the same consumer from different date.

montyself

Checking to see if this was ever answered, we have a similar situation where we want to combine several different fields of text based on an adjacent fields value.

Thanks,