Search results

Nailed it! Well done Hui and thank you very much. I half understand the formula and now realise that entering a region for each row (so no blanks)would simplify it. I love it that such a forum exists and people are kind enough to help out others.

Hope this link to hot file works copy pasted the formula in D1 Any number i enter into E2 reports back "Wales" http://hotfile.com/dl/119561800/be88414/Book1.xlsx.html

Thanks Hui Does it matter where i put the formula? its throwing uop a few wrong results

Thanks again Hui all regions are in A lower numbers in B and higher numbers in C and yes the numbers under each region refer to that region I'll try and upload the actual data as you suggested if it will make this clearer.

Thanks for the ultra quick repsonse BTW Hui, Am i right in thinking that VLOOKUP and MATCH require a list? I don't have a list of 1000 Through 1999, i just know that between 1000 and 1999 refers to wales, so if i enter 1824 excel will display "wales" or 2150 will return "England"etc. My boss...

Thanks Hui I've already read it, thinking it was close to what i wanted, but i'll grab a large cup of coffee and try and digest it again.

hI Guys, Apologies for the long message i'm new to chandoo (about a month),(joined today)and a baby in excel years (about 2 months)ive learnt loads here but am baffled at 99.9r% of it,anyways I have to enter a number into a blank cell that will return a country or region the number refers to...