LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15,768
Default formula question

"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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Another formula question WendyBTR8860 Excel Worksheet Functions 2 January 11th 07 06:42 PM
formula question Dave F Excel Discussion (Misc queries) 2 September 15th 06 11:54 PM
Newbie Question - Subtraction Formula Question [email protected] Excel Discussion (Misc queries) 3 May 5th 06 05:50 PM
Formula Question shadrach Excel Discussion (Misc queries) 1 May 10th 05 08:25 AM
Formula Question JDT Excel Discussion (Misc queries) 2 January 30th 05 01:17 PM


All times are GMT +1. The time now is 04:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"