LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Puzzled Percy
 
Posts: n/a
Default How do I select a value from a table based on 2 conditional refs?

I'm trying to select a value from a table based on 2 variable references.

If been looking at using a VLOOKUP function to do this but because there are
2 dependant references I'm a little stuck. I thought that maybe a VLOOKUP
with a MATCH function incorporated might be an option as the entries in each
column are not unique.

To give you an example of what I am trying to achieve I done the table below.

Basically if F1=9 & G2=2 then select C1 (*)

A B C D F G
1 9 3 * % 9 2
2 9 2 % &
3 9 1 # *
4 7 3 * %

Thanks
 
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
conditional formating cells i Excel based on other cells values Elias Petursson Excel Worksheet Functions 3 May 23rd 06 06:45 PM
Filter based on Pivot table michaelp Excel Worksheet Functions 3 December 7th 05 12:48 AM
Keep conditional format when "show pages" from Pivot table Angus Excel Discussion (Misc queries) 7 June 30th 05 01:33 PM
can not select conditional formatting gbeard Excel Worksheet Functions 2 April 10th 05 06:15 PM
How to create a calculated field formula based on Pivot Table resu dha17 Excel Discussion (Misc queries) 1 December 15th 04 05:39 AM


All times are GMT +1. The time now is 08:19 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"