yogi_Present Combined Inventory From Items In Sheet1 and Sheet2

Google Spreadsheet   Post  #2539

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Nov-12-2018

question by: Artem Okhrei
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/kG4nDp9-lT8;context-place=forum/docs

How to combine two sheets into one using first column values as key?
Hi! I have some troubles with the following. Really tried vlookup but failed to do that.

I have two sheets.

The first sheet looks like this:

/category/lamps/                    15

/category/sofas/                     110

/category/chairs/                    4

and the second one looks like this:

/category/lamps/                    20

/category/sofas/                     50

/category/tables/                    230

And I want to build the third combined sheet which looks like this:

/category/lamps/                    15                        20

/category/sofas/                     110                      50

/category/chairs/                    4                           -

/category/tables/                    -                            230

Please, help. I've been working with this three hours and no result unfortunatelly. Thanks in advance!