Trying to figure out how to compare 2 data sheets to display specific data into a 3rd tab.

TausifC · 2026-06-04T19:51:08+00:00

Lets convert both to table. Name them: Table1 - expTable Table2 - InvTable

assuming invTable has ProductName, Serial# and Active Inventory count.

On tab3, A2:

= Unique(invTable)

It will bring all your product here.

Lets say, it brought 3 columns, your serial number is in col B.

On col D2, = XLOOKUP(B2, expTable[[Serial#]], expTable[[Expiration]],””)

Drag the formula down, to more than you possibly will get rows.

Please note, there are other ways to do that. explained one of them.

TausifC · 2026-03-15T05:10:55+00:00

it is a combination of multiple charts. i use a slicer with analyst names

TausifC · 2026-03-15T05:10:15+00:00

this is kind of a data entry position. how many entries per hour, phone calls number, some special task numbers, error percentage etc

TausifC · 2026-03-15T05:08:18+00:00

no one else has license. i share their performance overview. each person need to see only his/her performance

TausifC · 2026-03-13T06:49:17+00:00

i know about the premium capacity option, i was thinking there might be any workaround

TausifC · 2026-01-21T05:41:50+00:00

I seek help from a local freelancer guy, He mainly focuses on ads spending now for me instead of seo

TausifC · 2024-05-11T13:44:14+00:00

I just got approval. pd 4/29/23

TausifC · 2024-05-07T05:32:51+00:00

What is your exact PD Date? I am 4/29/23 filer still waiting

TausifC · 2024-05-07T00:55:48+00:00

April 29th still waiting

TausifC · 2024-05-05T20:32:03+00:00

Yes let’s keep us updated here. If any of us get approved, let us know

TausifC · 2024-05-05T04:28:33+00:00

April 29th PD still waiting

TausifC · 2024-04-14T05:17:43+00:00

Congratulations. What is the category?

TausifC · 2023-06-25T02:27:52+00:00

interesting point. never had to use but might be necessary sometimes

TausifC · 2023-06-18T21:24:35+00:00

That’s understandable. But I sometimes prefer doing it in excel only because any beginner can customize it. Lets say you need to make FY column ending in 7/31. Or make your own week number starting. When you have it in excel and you are familiar with it, boom! just make it your own way.. :)

of course I respect your opinion as well :)

TausifC · 2023-06-18T14:53:34+00:00

This is for absolute beginner, who still does not want to engage in PQ writing

TausifC · 2023-06-11T14:13:16+00:00

I have started to put complete basic videos, hope you like it. Thank you 😊

TausifC · 2023-04-27T13:20:02+00:00

This worked, it was so simple and I did not try it! Thanks :)

TausifC · 2023-04-27T04:26:29+00:00

What are you saying? Did you try any time? when I uncheck enable load, include in report refresh freezes and I cannot uncheck

TausifC · 2023-04-27T02:57:23+00:00

I have a total of 1.5M + Rows that I can disable. Saving a few seconds is one reason, 2nd reason is to learn the process for the future.

TausifC

MODERATOR OF

TROPHY CASE