List not working

[tigger2]

I have a spreadsheet in which I have a list validation to determine currency type. A formula below looks at that result and does a VLOOKUP to a master page (same file) and returns the correct pricing. The list validation isn't working on every page and I can't understand why? My data is on the same page like it's supposed to be. I also tried a list combo box which would work just as well, but when i do that, the lookup doesn't seem to work. Any ideas what could be wrong here?

First time poster

[tigger2]

Here's the example, maybe it's a VLOOKUP problem:

=IF(G$14="1",VLOOKUP(C18,Master!$B$2:$E$183,3,FALSE),VLOOKUP(C18,Master!B2:E183,4,FALSE))

Thanks . . .

[Aladin Akyurek]

On 2002-04-23 10:14, tigger2 wrote:
Here's the example, maybe it's a VLOOKUP problem:

=IF(G$14="1",VLOOKUP(C18,Master!$B$2:$E$183,3,FALSE),VLOOKUP(C18,Master!B2:E183,4,FALSE))

Thanks . . .

If =ISNUMBER(G$14) is TRUE, then change your formula to:

=VLOOKUP(C18,Master!$B$2:$E$183,IF(G$14=1,3,4),0)


[ This Message was edited by: Aladin Akyurek on 2002-04-23 10:18 ]

[tigger2]

Wow, thanks! I see what you did . . .

Appreciative user!