Currency picking - out of my depth 1

[redshep]

Hi,

I am using the following formula to get the prices for my courses (namedrices list is located next to named:courses in the data sheet)

=IF(ISBLANK(D8),0,LOOKUP(D8,courses,data!C2:C15))

I now need to add to my namedrices in having a Euro and Sterling list. I have created a list with Euro and Sterling. I do no know how to get it so that when you pick Euro or Sterling it will pick up the correct list in the data sheet.

The prices are constant (I do not need to work them out from an exchange rate).

I hope that makes sense. I can always email the worksheet if that would help. Many thanks,

Red

 

[DaleWatson123321]

Red,

I'm prepared to help out. Emailing the actual file is always a much preferred method of approaching and resolving a task.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[redshep]

Hi Dale,

Thanks for the quick response.

The formula works perfectly, you have saved me alot of time!

I have a feeling I might have to ask a few more questions in the future!!!

Regards,

Red