LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8
Default Lookup on two criteria


Dear all

I would like to create a lookup or index that finds a particular entry by
column and row. This is my data

part number month1 month2 month3 month4
123 10 20 30 40
456 50 60 70 80


On another sheet I have two selection cells, I have selected part number 123
and month 2, in another cell I want to see the result 20.

I hope this makes sense.

I really appreciate any help as I am relatively new to excel

Kathryn

 
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
Lookup Multiple Criteria return One answer cbanks Excel Worksheet Functions 3 January 26th 06 08:00 PM
Lookup with Multiple Criteria cbanks Excel Discussion (Misc queries) 1 January 26th 06 07:31 PM
Multiple criteria LOOKUP Leon Excel Worksheet Functions 2 December 22nd 05 01:13 PM
Lookup: 2 criteria maca Excel Discussion (Misc queries) 1 August 2nd 05 04:55 PM
Conditional Lookup on Multiple Criteria TBarker Excel Worksheet Functions 1 June 22nd 05 12:28 AM


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