Brains1983

stuck with a problem that google hasn't managed to help me fix yet. Anyone know MS Excel?

I'm 99% through the template I'm creating, however there is one cell I am stumped with. What needs to be displayed is the result of 2 drop down menus further up the template

based on my little table attached, if I have selected "50 Kg" from one drop down menu, and "Singapore" from the other one, what do I put in the cell so I am working on to so it knows to display "110"?

CanuckGrl

I don't entirely understand the question. Are you looking for a formula to be used in more than one cell that will give the value of, for example, 50kg and Singapore, 500kg and Dubai, etc., the answer of which will change based on different inputs?

If you simply want the "110" to appear in another cell, you just need to tell it to copy/link the value of whatever that cell number is.

Brains1983

Based on what two options the user has selected in the two drop downs (one will be the city, one will be the weight), I want the cell I am having trouble with tto show the number where they meet on the table I attached.

csdf

If the user selection city is in cell A1 and weight selection in A2, your city names are in cells b10:f10 and your weights are in cells A11:A14 then the formula would be:
=HLOOKUP(A1,$B$10:$F$14,MATCH(A2,$A$11:$A$14)+1,FA LSE)

The FALSE statement should be a complete word - not sure why it's being broken up.

For this to work you need to make sure that the user weight selection choices match exactly, character for character, the list in cells A11:A14. You can do this using Data Validation and a list.

OriginalSunshine

you will need to write nested AND IF statements

Brains1983

I wish I understood this

OriginalSunshine

then you need to learn to do it

teach yourself Brains

go to the help function, look for HLOOKUP or ANDIF in the button that says "function help" and follow the instructions

Casta

First of all I have to agree with the poster who said you had to learn. I can't emphasise enough how practice helps learn Excel. Nothing like learning from doing. Google often comes up with great links although admittedly sometimes it helps to know the function you'll need which isn't always easily known

Couple of links to help you understand how it works:
http://www.mrexcel.com/articles/exce...ndex-match.php
http://tipsindeed.com/excel-function...-in-excel.html

I've put the answer in an attached pic. A9 and B8 are Data Validation drop down lists so the answer in B9 changes when they do.

Good luck

OriginalSunshine

Casta, thanks! I learnt something new today
I've never used Index/Match before.

Brains1983

That worked perfectly, thank you very much. Karma Sent!

shiva

$5 to fix excel

go here

Brains1983

there's a dude on there that does a simpsons style caricature for you aswell.

Millhouse

I would suggest that you shouldn't be writing nested IF statements - much better ways of coming to the same answer (index and match combo).

In a former life I used to teach xhell. My advise was always to get rid of IF, AND, OR statements - they are confusing

OriginalSunshine

Very true. But I come from an ex Fortran 77 background, no index/match then, so I'm just being lazy since I can write nests easily

Irishbeekeeper

I like turtles!!