If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Hi all! We have been experiencing an issue on site where threads have been missing the latest postings. The platform host Vanilla are working on this issue. A workaround that has been used by some is to navigate back a page or two to re-sync the thread and this will then show latest posts. Thanks, Mike.

Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Excel Help!!

mik_da_man · 2006-02-01 20:06:41

Hey guys, I have a spreadsheet similar to the one attached and i need a formula that will populate values on one sheet from the other sheet based on a month choosen from a list. It is probably simple, but the only problem is that the format of the figures in the sheets cannot be changed i'm stumped at the mo All help…

01-02-2006 9:06pm

#1

mik_da_man

Hosted Moderators Posts: 9,952 ✭✭✭

Join Date: December 2004

Posts: 9692

Hey guys,

I have a spreadsheet similar to the one attached and i need a formula
that will populate values on one sheet from the other sheet
based on a month choosen from a list.

It is probably simple, but the only problem is that the format of the figures in the sheets cannot be changed

i'm stumped at the mo

All help appriciated

Cheers

Mik

0

Comments

#2 01-02-2006 9:20pm

leche solara

Registered Users, Registered Users 2 Posts: 2,160 ✭✭✭

Join Date: October 2004

Posts: 2047

Try
=IF(A2="Apr",Sheet2!F8)

0
#3 01-02-2006 9:34pm

mik_da_man

Hosted Moderators Posts: 9,952 ✭✭✭

Join Date: December 2004

Posts: 9692

Hi,

I know I can do this for one month.
but i need it to work for every month.

Some more examples of what i need may help

If May is choosen from list I want B6 to equal G8 from sheet2
if Dec is choosen from list I want B9 to equal N17 from Sheet2

Cheers

0
#4 01-02-2006 9:42pm

Capt'n Midnight

Moderators, Recreation & Hobbies Moderators, Science, Health & Environment Moderators, Technology & Internet Moderators Posts: 92,385 Mod ✭✭✭✭

Join Date: March 2003

Posts: 90623

You may have to use HLOOKUP or VLOOKUP.

0
#5 01-02-2006 9:58pm

leche solara

Registered Users, Registered Users 2 Posts: 2,160 ✭✭✭

Join Date: October 2004

Posts: 2047

Try this:

=HLOOKUP(A2,Sheet2!C5:N6,2,FALSE)

I think this will work

0
#6 01-02-2006 10:22pm

mik_da_man

Hosted Moderators Posts: 9,952 ✭✭✭

Join Date: December 2004

Posts: 9692

Cheers leche,

Here is the forumla i used

=HLOOKUP($A$2,Sheet2!$C$5:$N$21,4,FALSE)

Just have to change the row index number for each counrty needed

Thanks

Mik

0
Advertisement