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.
Bookmarks