Posted to microsoft.public.excel.misc

irvine79

external usenet poster

Posts: 21

Lkup formula is returning last value in result column, not lkup va

I have a lookup formula with a lookup value on sheet 1 and both lookup vector
and result vector are on sheet 2. The cell with the formula is on sheet 1.

formula - =LOOKUP(B1,Sheet2!!A2:A4,Sheet2!G2:G4)

the formula returns the last value from column G when it should be returning
the value in G2. Help!

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
Date formulas	DRondeau	Excel Discussion (Misc queries)	7	September 6th 06 09:53 PM
macro	unouwanme	Excel Discussion (Misc queries)	9	August 31st 06 09:38 PM
how can i multiply two columns	edgar	Excel Worksheet Functions	7	March 2nd 06 03:29 PM
Need to Improve Code Copying/Pasting Between Workbooks	David	Excel Discussion (Misc queries)	1	January 6th 06 03:56 AM
Formula Problem - interrupted by #VALUE! in other cells!?	Ted	Excel Worksheet Functions	17	November 25th 05 05:18 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us