Posted to microsoft.public.excel.worksheet.functions

Connie Martin Connie Martin is offline

external usenet poster

Posts: 251

Troubleshoot LOOKUP, please

Why does this lookup work sometimes, and sometimes not? Formula is:
=IF(D10="","",LOOKUP(D10,P:P,Q:Q)). Right now D10 is giving me the results
in the row above in column Q, if you understand what I mean. The data in D10
is found in P35 and instead of giving me Q35 data, it's giving me Q34. But,
it doesn't always do this. Sometimes it works beautifully. What gives?
Connie

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
NETWORKDAYS Troubleshoot	DOUG ECKERT[_2_]	Excel Discussion (Misc queries)	8	September 2nd 08 02:22 PM
Troubleshoot help	Whitney	Excel Discussion (Misc queries)	3	April 3rd 08 11:03 PM
troubleshoot a workbook for me?	[email protected]	Excel Discussion (Misc queries)	1	November 22nd 05 07:01 PM
troubleshoot absolute value	Sus	Excel Worksheet Functions	3	October 27th 05 05:46 PM
Troubleshoot a bug in Excel	[email protected]	Excel Discussion (Misc queries)	1	October 17th 05 02:59 AM

All times are GMT +1. The time now is 01:14 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us