Choosing a service with a formula

jpsabourin@quickbusiness.com

Guest

Posts: n/a

8th May 2007

This is my lookup on the same spreadsheet. I does what I need it to.

=IF(ISNA(VLOOKUP(F18,$AH$1:AS$2000,12,0)),"",VLOOKUP(F18,$AH$1:AS
$2000,12,0))

The PROBLEM, is how do the I get the VLOOKUP to formula to choose any
cell with the service

i.e, The service is "Good" vlookup has located that service but how
do I get the formula of one cell to be any cell in a column

Service "Good" is on line AH1, but I would like to have cell AJ1 to
accept any date time shown in column c1 to c2000.

Thanks JP

« File size MASSIVE but why? | Time calculation in excel »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
help with choosing formula	TWP	Microsoft Excel Worksheet Functions	3	12th Mar 2009 03:32 PM
Choosing a Formula Based on a Value	Rob Fox	Microsoft Excel Programming	4	4th Feb 2009 07:09 PM
Formula help for choosing from a set of values	ccclwilson	Microsoft Excel Worksheet Functions	5	21st Dec 2007 04:28 AM
print by service/scrip choosing the printer/paper tray	Pierre	Windows XP Print / Fax	0	15th Oct 2007 08:46 PM
Excel formula(?) for choosing only 1 cell..	=?Utf-8?B?Y2p0ajQ3MDA=?=	Microsoft Excel Misc	1	24th Nov 2005 10:36 AM