stacyjhaskins

Posts: n/a

hlookup #N/A

I can't figure out why I am getting #N/A for this.

=hlookup(A1, range of the table, 2) returns #N/A, but when I replace the
lookup value with the value in A1 it returns the correct answer.

Please help me. : (

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
HLOOKUP FUNCTION	Effie	Excel Worksheet Functions	0	May 24th 05 04:04 PM
keep the formatting of the cell found using Hlookup	Denny	Excel Discussion (Misc queries)	4	May 13th 05 09:54 PM
Vlookup and Hlookup	Phlogiston2312	Excel Worksheet Functions	1	April 21st 05 04:59 PM
How do I find a value in an array (VLOOKUP? HLOOKUP?)	M Skabialka	New Users to Excel	2	March 11th 05 02:52 AM
SUMIF - HLOOKUP Combination	Mark	Excel Worksheet Functions	1	February 4th 05 08:03 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us