Confused

Posts: n/a

Lookup

I am trying to use the lookup function, but excel is returning the wrong
result. My formula is LOOKUP(E53,AG1:AG55,AH1:AH55) where e53 is a value
inputted by the user. I want Excel to find the value in e5s in column ag and
grab the corrsponding data in column ah. it isnt finding the corrsponding
data in ah.

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
how do i get mutiple values using vlookup in excel, lookup value .	Abhijeet	Excel Discussion (Misc queries)	4	May 19th 05 04:30 AM
lookup with 2 criteria	LoriM	Excel Discussion (Misc queries)	5	January 7th 05 05:39 PM
Lookup Function	Christopher Anderson	Excel Discussion (Misc queries)	3	January 5th 05 03:38 PM
need check two worksheets to lookup a value	Clay	Excel Discussion (Misc queries)	2	January 5th 05 08:35 AM
HELP -- probably a LOOKUP problem	Liz-In-USA	Excel Discussion (Misc queries)	3	December 9th 04 12:18 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us