Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 354

lookup error???

why lookup is not working and returning #N/A ? thanks

doing :
=LOOKUP(PRET,G4:G13,F4:F13) on the range below,
the result should be 990, it works only for the first 8 items in the lookup
array

PRET

990 SIM1
990 SIM2
990 SIM3
990 SIM4
990 SIM5
990 SIM6
990 TLOW
990 THIGH
990 PRET
990 POST

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
LOOKUP error	Kelly	Excel Worksheet Functions	4	June 7th 07 11:47 PM
LOOKUP and #N/A Error	Poody	Excel Worksheet Functions	1	January 21st 07 11:32 AM
LOOKUP and #N/A Error	Mike	Excel Worksheet Functions	1	January 19th 07 08:13 PM
Lookup error	Andmor	Excel Discussion (Misc queries)	1	December 6th 06 10:51 PM
lookup error!	via135	Excel Worksheet Functions	2	June 15th 06 08:55 PM

All times are GMT +1. The time now is 05:27 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us