Help with formula

%3CLINGO-SUB%20id%3D%22lingo-sub-3388957%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3388957%22%20slang%3D%22en-US%22%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1392814%22%20target%3D%22_blank%22%3E%40ChefJohnH53%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3ETo%20help%20someone%20help%20you%2C%20please%20upload%20either%20an%20example%20workbook%2C%20some%20images%20of%20the%20sheets%20in%20question%20or%20both.%3CBR%20%2F%3E%3CBR%20%2F%3EPlease%20also%20include%20the%20exact%20definition%20of%20the%20formula%20that%20doesn't%20work%20and%20some%20description%20of%20what%20you%20are%20expecting%20to%20happen.%3CBR%20%2F%3E%3CBR%20%2F%3EWith%20this%20information%2C%20someone%20will%20be%20able%20to%20help%20you%20quickly.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3388976%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3388976%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1392814%22%20target%3D%22_blank%22%3E%40ChefJohnH53%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECould%20you%20please%20give%20bit%20more%20details%20-%20sample%20file%20or%20at%20least%20screenshot%20with%20formula%20you%20use.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3388920%22%20slang%3D%22en-US%22%3EHelp%20with%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3388920%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20data%20in%20two%20different%20worksheets%2C%20on%20a%20third%20worksheet%20I%20need%20data%20from%20one%20cell%20of%20the%20first%20worksheet%20in%20one%20cell%20and%20the%20corresponding%20info%20from%20the%20second%20worksheet%20in%20another%20cell.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20was%20trying%20to%20us%20the%20IFERROR(VLOOKUP)%20FUNCTION%20but%20it%20does%20not%20work.%20Any%20help%20would%20be%20appreciated.%20Thank%20you%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22ChefJohnH53_0-1652814623883.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F372528iC0E87FD8957BD81F%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22ChefJohnH53_0-1652814623883.png%22%20alt%3D%22ChefJohnH53_0-1652814623883.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22ChefJohnH53_1-1652814648291.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F372532i5ADCC6807F512D32%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22ChefJohnH53_1-1652814648291.png%22%20alt%3D%22ChefJohnH53_1-1652814648291.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22ChefJohnH53_2-1652814681576.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F372534iF0457E3C6AB91594%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22ChefJohnH53_2-1652814681576.png%22%20alt%3D%22ChefJohnH53_2-1652814681576.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EOn%20the%20third%20photo%20cell%20%22C11%22%20equals%20the%20value%20from%20first%20photo%20cell%20%22B6%22.%20I%20need%20cell%20%22C12%22%20to%20equal%20the%20corresponding%20number%20from%20cell%20%22B%22%20from%20the%20second%20photo.%20This%20is%20three%20different%20worksheets.%3CBR%20%2F%3EI%20want%20to%20be%20able%20to%20type%20a%20item%20in%20the%20menu%20worksheet%20and%20for%20it%20to%20automatically%20change%20on%20the%20production%20worksheet.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3388920%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3389621%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3389621%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20posted%20pictures%20and%20tried%20to%20explain%20what%20I%20am%20trying%20to%20accomplish%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1390870%22%20target%3D%22_blank%22%3E%40flexyourdata%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3389629%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3389629%22%20slang%3D%22en-US%22%3EI%20have%20updated%20the%20post%20with%20pictures%20and%20tried%20to%20explain%20what%20it%20is%20I%20am%20trying%20to%20accomplish.%3C%2FLINGO-BODY%3E
New Contributor

I have data in two different worksheets, on a third worksheet I need data from one cell of the first worksheet in one cell and the corresponding info from the second worksheet in another cell. 

I was trying to us the IFERROR(VLOOKUP) FUNCTION but it does not work. Any help would be appreciated. Thank you  

 

ChefJohnH53_0-1652814623883.pngChefJohnH53_1-1652814648291.pngChefJohnH53_2-1652814681576.png

On the third photo cell "C11" equals the value from first photo cell "B6". I need cell "C12" to equal the corresponding number from cell "B" from the second photo. This is three different worksheets.
I want to be able to type a item in the menu worksheet and for it to automatically change on the production worksheet.

4 Replies
Hi @ChefJohnH53

To help someone help you, please upload either an example workbook, some images of the sheets in question or both.

Please also include the exact definition of the formula that doesn't work and some description of what you are expecting to happen.

With this information, someone will be able to help you quickly.

@ChefJohnH53 

Could you please give bit more details - sample file or at least screenshot with formula you use.

I have posted pictures and tried to explain what I am trying to accomplish @flexyourdata 

I have updated the post with pictures and tried to explain what it is I am trying to accomplish.