Find a value from another worksheet and put it in another

[Lao]

Hi all!

I found this forum googling around for my problem. I registered thinking I can get the help that I need, as I need it really really fast.


I have 2 files: STOC and PRODUSE (the last one is with multiple sheets, column and rows, but I'm only interested in one sheet, "Products").

This is an example of what I need, but not even sure what function I need:

File PRODUSE, column L10=96535010
96535010 is searched in STOC (range from C2:C2500) and found in cell C346
I want the value from STOC cell E346 to show in K10 cell in PRODUSE.

If L10 is not found in STOC, cells C2:C2500, put value 15 in PRODUSE, cell K10.




I wonder if the IF function will do the trick. I don't know how to return the value of the cell near where the value was found.

[Lao]

For anyone who needs something similar, I solved it with this:

Please Login or Register  to view this content.