lookup a value from another sheet, copy and paste the results in another sheet

[sniper1]

Hi,

So I have this small project that I need to enter a date in the "Data sheet" tab, using vlookup to look for product inventory category (QTY1 or QTY2) and copy the values from "sales by region" tab and paste them into "data sheet" tab horizontally. The data in "sales by region is by column, but the same value will need to be transpose on the "Data sheet" tab.

So if I enter the date in column A, and the product inventory category in column B, the vlookup will check that with the value of B3 ("sales region") sheet and copy those values and paste in the second tab accordingly.

Hope this makes sense.

Thank you Excel Ninjas!!!!!

[JohnTopley]

in C7

=INDEX(Table1[[QTY 1]:[QTY 2]],MATCH('Data sheet'!C$2,Table1[Region],0),MATCH($B7,Table1[[#Headers],[QTY 1]:[QTY 2]],0))

COPY (not drag) to columns D and E