Using If and Vlookup together.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Honey - 18 Apr 2007 14:43 GMT

Hello

Here is the problem - If cell A1 has 0 then I want B1 to be
0...however if A1= 1 I want B1 to display the result from a look up
table.

I just keep getting error messages and I am ready to chuck the
Computer out of the window.....I am using Office Excel on Mac but that
does not normally make a difference to formulas.

Thank you!!

Lyndsey

Reply to this Message

Peo Sjoblom - 18 Apr 2007 14:52 GMT

=IF(A1<>1,0,VLOOKUP(lookup_value,lookup_table,2,0))

adapt to fit

Signature

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)

> Hello
>
[quoted text clipped - 9 lines]
>
> Lyndsey

Reply to this Message

Mike - 18 Apr 2007 14:56 GMT

Lyndsey,

Try this in B1

=IF(A1=0,A1,IF(A1=1,VLOOKUP(A2,H1:I10,2,FALSE),"Unspecified"))

Note that the value to look up if A1 is 1 is in A2 and the lookup array is
H1 to I10 all of which can be changed as required. You didn't say what you
wanted for other values in A1o the formula will return "Unspevcified"

Mike

> Hello
>
[quoted text clipped - 9 lines]
>
> Lyndsey

Reply to this Message

Ron Coderre - 18 Apr 2007 14:58 GMT

If you post the formula that isn't working, you'll likely get a custom,
working formula back....
otherwise, you'll receive a generic formula that may or may not solve your
problem.

***********
Regards,
Ron

XL2002, WinXP

> Hello
>
[quoted text clipped - 9 lines]
>
> Lyndsey

Reply to this Message

Bob Phillips - 18 Apr 2007 14:58 GMT

see other thread

Signature

---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

> Hello
>
[quoted text clipped - 9 lines]
>
> Lyndsey

Reply to this Message