Results 1 to 9 of 9

Simplify a Formula

Threaded View

alan_stephen75@ Simplify a Formula 02-18-2008, 07:00 PM
VBA Noob Maybe VBA Noob 02-18-2008, 07:08 PM
alan_stephen75@ Sorry it’s not working as it... 02-19-2008, 07:04 AM
daddylonglegs Try ... 02-19-2008, 07:13 AM
alan_stephen75@ Thanks for your help I am... 02-19-2008, 09:48 AM
daddylonglegs Let me get this... 02-19-2008, 08:30 PM
alan_stephen75@ Sorry daddylonglegs no it... 02-20-2008, 07:54 AM
daddylonglegs Doesn't the formula I posted... 02-20-2008, 08:26 AM
alan_stephen75@ Both work, brilliant! someday... 02-20-2008, 09:32 AM
  1. #8
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    Microsoft 365
    Posts
    14,720
    Doesn't the formula I posted work - with sheet name added it would be

    =LOOKUP(REPT("z",255),CHOOSE({1,2,3},"",VLOOKUP( Z46,Game1!$Y$15:$Z$21,2,0),VLOOKUP( Z46,Game1!$AF$15:$AG$21,2,0 )))

    or perhaps simpler

    =IF(Z46="","",VLOOKUP( Z46,IF(MOD(Z46,2),Game1!$Y$15:$Z$21, Game1!$AF$15:$AG$21),2,0))
    Last edited by daddylonglegs; 02-20-2008 at 08:28 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1