Posted to microsoft.public.excel.worksheet.functions

PJ Murph[_2_] PJ Murph[_2_] is offline

external usenet poster

Posts: 19

Lookup or Vlookup?

A B C D E F G

Drawing # Date PICKS
1 02-01-2008 4 12 15 32 39
2 02-02-2008 1 3 7 9 30
3 02-03-2008 3 20 21 32 38
4 02-04-2008 2 11 18 27 33
5 02-05-2008 1 12 23 25 40

I need to search columns C through G to determine the date (column B) when a
specific number (let's say 12) was chosen. Please help.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
vlookup and lookup	Ruth	Excel Worksheet Functions	12	December 4th 08 02:17 PM
=IF(AND(LOOKUP(F3,A21:A42)=F3,LOOKUP(B4,B21:B42)=B4),(VLOOKUP(B4,B	RWD715	Excel Worksheet Functions	9	October 10th 08 10:11 PM
Help with Lookup(), VLookup	phil	Excel Worksheet Functions	6	February 8th 07 01:06 AM
LOOKUP or VLOOKUP	MichelleS	Excel Worksheet Functions	9	October 20th 06 02:11 PM
Lookup without VLOOKUP?	J	New Users to Excel	6	November 17th 05 06:57 AM

All times are GMT +1. The time now is 06:48 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us