Excel Formulas

Resolved · Low Priority · Version 2010

Tue 10 Jan 2012, 14:04 Delegate 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:06 Trainer 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:27 Trainer 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:07 Delegate 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:53 Trainer 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:01 Trainer 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:01 Trainer 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 courses