Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
"David" wrote in message
... T. Valko wrote: Ok... With... Combo box 1 linked to Sheet2 A2 = 2 Combo box 2 linked to Sheet2 A3 = 8 Lookup table on Sheet1 A1:I9 This formula entered on Sheet1: =IF(AND(Sheet2!A21,Sheet2!A31),VLOOKUP(Sheet2!A2 ,A1:I9,Sheet2!A3+1,0),"") Thank you soooo much it worked GREAT You're welcome. Thanks for the feedback! -- Biff Microsoft Excel MVP |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Another formula question | Excel Worksheet Functions | |||
formula question | Excel Discussion (Misc queries) | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
Formula Question | Excel Discussion (Misc queries) | |||
Formula Question | Excel Discussion (Misc queries) |