Using IF with LOOKUP

[gally]

I was wondering if anybody was able to help I have attached a formula I need a hand with.

Please Login or Register  to view this content.

If I wanted to add to this code that in Cell A1 for example there is either the value 1 or 2 - can I add an IF statement to the above code for example - IF cell A1 = 1 then as per the code above but if A1 =2 then the LOOKUP ranges would be different i.e. instead of....

Please Login or Register  to view this content.

Is that to many arguments if so is there anyway I can work around it?

Thank you for looking

Gally

[Ace_XL]

Try

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

[jeffreybrown]

How about

Please Login or Register  to view this content.

[gally]

Hi Ace_XL and Jeff - thank you both for taking the time to reply. I ended up using the second suggestion by Ace the =IF.

All the suggestions much appreciated though.

Kind Regards
Gally

[jeffreybrown]

You're welcome and thanks for the feedback. Glad it worked out for you and we are happy to have helped...