Stock Kontrol formul help

[ogecen]

There is an incomplete formula in cell J3,
If the product code G3 (RM007) is in column A, the 3.975 information in column E should come to J3,
so far it is okincomplete formula:
Example: If the product code in G5 (RM029) is not in column A, the information in column D on the Stock page should come, I wrote the correct information manually in J5.

Best Regards,

[AliGW]

In J3 copied down:

=IF(G3="","",IFERROR(VLOOKUP(G3,$A$4:$E$26,5,0),VLOOKUP(G3,Stock!$B$31:$D$1327,3,0)))

Surprised you weren't able to work this out for yourself, though.

[ogecen]

Hi AliGW

Thank you for your feedback.
I adapted your formula, J5 value came out as zero, but it should have been 1500

[josephteh]

The correct formula should be:
=IF(G3="","",IFERROR(VLOOKUP(G3,$A$3:$E$26,5,0),VLOOKUP(G3,Stock!$B$1:$D$1327,3,0)))

[AliGW]

I adapted your formula, J5 value came out as zero, but it should have been 1500

There was a typo in my post (now corrected - thanks, Joseph).

[josephteh]

You are welcome, Ali.

[ogecen]

Hello, AliGW and josephteh,
I am very grateful for your feedback.

Is it possible to make a change in the formula as follows?

If, according to the Codes, there is a negative value in column E, the value in column H should come

Example:
Code RM069
Since there is a negative (-) 13.164 in cell E13,

1.600 should be written in J4,

Best regards,

[AliGW]

Yes, it's possible. Looking at the amendment I made to your original formula, have a go yourself, please, then share what you have tried. You will learn nothing if you expect us to keep spoon-feeding you every time you need a minor adjustment.

[ogecen]

AliGW, My Teacher,

you gave me a difficult assignment,
should I use the search and find command

[ogecen]

AliGW,

Is it an example?

[AliGW]

Does it do what you want?

You should avoid using full column references like A:A.

[ogecen]

yes it did the job,
We did it together with two friends in the office.

A:A thank you very much for your warning

[AliGW]

There you go - applied learning - great!