Home

I need help with excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1055124%22%20slang%3D%22en-US%22%3EI%20need%20help%20with%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1055124%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20to%20indicate%20price%20with%20variable%20situations%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20IF%20and%20AND%20formulas%20but%20I%20couldnt%20do.Is%20there%20anybody%20WHO%20can%20help%20to%20me%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1055124%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1055139%22%20slang%3D%22en-US%22%3ERE%3A%20I%20need%20help%20with%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1055139%22%20slang%3D%22en-US%22%3EHi%2C%20could%20you%20provide%20some%20more%20information%20including%20an%20example%20and%20ideally%20a%20sample%20file%20explaining%20in%20as%20simple%20terms%20as%20possible%20what%20you%20are%20trying%20to%20do.%20Thanks%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1055165%22%20slang%3D%22en-US%22%3ERE%3A%20I%20need%20help%20with%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1055165%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9832%22%20target%3D%22_blank%22%3E%40Wyn%20Hopkins%3C%2FA%3E%26nbsp%3BHello%2CAs%20you%20see%20on%20the%20picture%2CI%20want%20to%20see%20price%20placed%20on%20the%20right%20section%20when%20I%20choose%20model%2Cengine%2Cyear%20and%20colour%20according%20to%20their%20price%20on%20the%20left%20section%20.Thank%20you%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F160646i2CC5C2DC78A34304%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22picture.png%22%20title%3D%22picture.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1055176%22%20slang%3D%22en-US%22%3ERE%3A%20I%20need%20help%20with%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1055176%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F482371%22%20target%3D%22_blank%22%3E%40OnurhanToy%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20variant%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3DIFNA(LOOKUP(2%2C1%2F(%24A%3A%24A%3D%24I5)%2F(%24B%3A%24B%3D%24J5)%2F(%24C%3A%24C%3D%24K5)%2F(%24D%3A%24D%3D%24L5)%2C%24E%3A%24E)%2C%22no%20such%22)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1055230%22%20slang%3D%22en-US%22%3ERE%3A%20I%20need%20help%20with%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1055230%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20so%20much%20for%20comment.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20not%20possible%20using%20this%20formula%20%3F%3C%2FP%3E%3CP%3E%3DIF(AND(I5%3D''CL%C4%B0O''%3BJ5%3D''1.9''%3BK5%3D''2018%3BL5%3D''SARI'')%3B166800)%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1055234%22%20slang%3D%22en-US%22%3ERE%3A%20I%20need%20help%20with%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1055234%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F482371%22%3E%20target%3D_blank%20target%3D_blank%40OnurhanToy%3C%2FA%3E%26nbsp%3BHi%2C%20allow%20me%20to%20chip%20in..%20the%20way%20I%20see%20it%2C%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%3E%20target%3D_blank%20target%3D_blank%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3Bmethod%20is%20better%20in%20the%20sense%20that%20he's%20looking%20up%20the%20entire%20range%20so%20you%20can%20use%20that%20one%20formula.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20one%20you%20indicated%2C%20If(and%3B%20it%20is%20very%20specific%20and%20may%20require%20changes%20in%20order%20to%20work%20perfectly%20should%20you%20have%20new%20data%20going%20forward.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1055256%22%20slang%3D%22en-US%22%3ERE%3A%20I%20need%20help%20with%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1055256%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F478344%22%3E%20target%3D_blank%40crazyshoots%3C%2FA%3E%26nbsp%3B%20Thank%20you%20very%20much%20for%20your%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'll%20try%20both%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
OnurhanToy
New Contributor

Hello everyone,

 

How to indicate price with variable situations?

 

I need IF and AND formulas but I couldnt do.Is there anybody WHO can help to me

 

 

6 Replies
Hi, could you provide some more information including an example and ideally a sample file explaining in as simple terms as possible what you are trying to do. Thanks

@Wyn Hopkins Hello,As you see on the picture,I want to see price placed on the right section when I choose model,engine,year and colour according to their price on the left section .Thank you

picture.png

@OnurhanToy 

As variant

=IFNA(LOOKUP(2,1/($A:$A=$I5)/($B:$B=$J5)/($C:$C=$K5)/($D:$D=$L5),$E:$E),"no such")

@Sergei Baklan 

Thank you so much for comment.

 

Is it not possible using this formula ?

=IF(AND(I5=''CLİO'';J5=''1.9'';K5=''2018;L5=''SARI'');166800) 

@OnurhanToy Hi, allow me to chip in.. the way I see it, @Sergei Baklan method is better in the sense that he's looking up the entire range so you can use that one formula.

 

The one you indicated, If(and; it is very specific and may require changes in order to work perfectly should you have new data going forward.

@crazyshoots  Thank you very much for your help.

 

I'll try both

Related Conversations