Lookup to left column

[Junarkar]

Hi

This may be a common question but I couldn't find a solution.

Item code	Req Qty	Scan Qty	Balance	Location	24 | 559	8903742608270​	<<< Fill ITEM CODE here
1000007775234​	5​	2​	3​	Max KLRDC
1000007775311​	4​	1​	3​	Max KLRDC
1000007775369​	4​	1​	3​	Max KLRDC
8903742577866​	4​	1​	3​	Purackal Fashions-Titus-Thiruvalla-Max
1000007771363​	3​	1​	2​	Max KLRDC		Pending To Scan
1000007775104​	3​	1​	2​	Max KLRDC		Item code	Req Qty	Scan Qty	Balance	Location
8903742478194​	3​	1​	2​	Purackal Fashions-Titus-Thiruvalla-Max
8907352577582​	3​	1​	2​	Max-Sana Arcade-Changanassery
1000007775094​	2​	1​	1​	Max KLRDC
1000007804067​	2​	1​	1​	Max KLRDC
8903742563777​	2​	1​	1​	Purackal Fashions-Titus-Thiruvalla-Max
8907352576752​	3​	2​	1​	Kurisupally Junction-Pala-Max
1000006612865​	1​	1​	0​	Max KLRDC
1000006612982​	1​	1​	0​	Max KLRDC
1000006646722​	1​	1​	0​	Max KLRDC
1000007552347​	1​	1​	0​	Max KLRDC
1000007590218​	1​	1​	0​	Max KLRDC

If the balance is not zero then those details should come in "Pending To Scan".

How to achieve this.

 

[Luke M]

Check out this tutorial on how to extract a list based on criteria.

https://chandoo.org/wp/formula-forensics-003/

 

[vletm]

Junarkar
This seem to be 'next step' or 'different variation' of Your previous thread

Lookup values with additional checking

Hi all I have an excel file which has two sheets. 1st sheet with data, 2nd sheet is used to enter bar codes (not manually but with scanner). While entering a bar code, I need two figures - Location (to which that product will be delivered) and Qty. (the total qty. to be send). I need to send...

chandoo.org

In which I marked those 'not zero balanced' with yellow as below.

Of course, I could make Your needed 'Pending To Scan'-text as well as those yellows, almost anywhere You would like ...?

 

[Junarkar]

Junarkar
This seem to be 'next step' or 'different variation' of Your previous thread

Lookup values with additional checking

Hi all I have an excel file which has two sheets. 1st sheet with data, 2nd sheet is used to enter bar codes (not manually but with scanner). While entering a bar code, I need two figures - Location (to which that product will be delivered) and Qty. (the total qty. to be send). I need to send...

chandoo.org

In which I marked those 'not zero balanced' with yellow as below.
View attachment 64106
Of course, I could make Your needed 'Pending To Scan'-text as well as those yellows, almost anywhere You would like ...?

Yes vietm, that is highlighted in Yellow. What I thought was after completing all the scan, if all those bar codes not equal to 0 will come together in the left side, it would be great. I mean applying a filter will also solve the issue. I was just thinking about this.

Thanks

 

[Junarkar]

Check out this tutorial on how to extract a list based on criteria.

https://chandoo.org/wp/formula-forensics-003/

Thanks Luke.

 

[vletm]

Junarkar
Those Yellows
as You would notice
a) rows color will update after EVERY change = live status
b) rows which has balance other than ZERO are always top
as well as
other rows are sorted in order.
If every row will have ZERO balance then NONE yellow.

What would You filter?

 

[Junarkar]

Thanks a lot vietm again… Sorry for the late replay. I was not available for some time.