98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel Formulas
Excel Formulas
Resolved · Low Priority · Version 2010
Tue 10 Jan 2012, 14:04Delegate Lisa said...
Lisa has attended:
Excel Introduction course
Excel Formulas
Hello,
I have an Excel spreadsheet with 2 tabs, 1st tab has a column with country names and their respective zones, i.e. Europe, Asia, etc in the 2nd column.
The 2nd tab has a list of countires, is there a formula I can use to automatically enter the correct countyr zone on the 2nd tab?
Many thanks
Wed 11 Jan 2012, 10:06Trainer Anthony said...
RE: Excel Formulas
Hi Lisa, thanks for your query. You'll need to use the VLOOKUP function to achieve this, which is something we cover on our advanced course. Have a look here for a quick walkthrough:
http://www.bettersolutions.com/excel/EDH113/YI519060881.htm
Hope this helps,
Anthony
Wed 11 Jan 2012, 10:27Trainer Doug said...
RE: Excel Formulas
Hi Lisa
Here's how to do what you asked with the country zones.
Suppose your Sheet1 looks like this
COUNTRY ZONE
UK Europe
France Europe
India Asia
Japan Asia
SA Africa
and Sheet2 looks like this
COUNTRY ZONE
Japan ?
UK
Type this Vlookup formula next to Japan in Sheet2 to show the correct zone.
=VLOOKUP(A2,Sheet1!$A$2:$B$6,2,FALSE)
The notes Anotny sent expain how the formula works which is all covered on our Excel Advanced course.
Let us know if it worked!
Regards
Doug
Wed 11 Jan 2012, 12:07Delegate Lisa said...
RE: Excel Formulas
Dear Anthony and Doug,
Thank you for getting back to me.
I've been trying VLOOKUP formula yesterday to match regions to my country names, only I was referring to a range on sheet 1 in my formula rather than the actual sheet.
Doug, I've just tried your formula, but I am only getting N/A results.
I've tried this both in Excel and CSV formats.
Regards,
Lisa
Mon 23 Jan 2012, 09:53Trainer Doug said...
RE: Excel Formulas
Hi Lisa
Maybe easiest for you to email your example and I can get back to you with why it says N/A. Send to
dougdunn56@gmail.com
Regards
Doug
Doug Dunn
Best STL
Fri 16 Nov 2012, 12:01Trainer Simon said...
RE: Excel Formulas
Hi Lisa,
I am currently in the process of trying to clear the outstanding items on the support forum. Can you please let me know whether Doug received your file and whether he responded to you.
Can you please reply to this email within 5 days otherwise the question will be marked as resolved.
Thank you for your assistance.
Regards
Simon
Fri 16 Nov 2012, 12:01Trainer Simon said...
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.
Fri 23 Nov 2012: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
