Posted to microsoft.public.excel.misc

snax500

external usenet poster

Posts: 49

lookup and offset formula

In Excel2007, I need a formula that will lookup an item in another file, find it and then give me the cell contents 3 rows up and 1 over to the right. For example...

file 1...

today 50
yesterday 100
tomorrow 200
xyz

today 20
yesterday 200
tomorrow 400
abc

file 2...
formula to lookup "xyz" and then give me today's amount = 50. the captions are in one column and the amounts in the next column. Thanks

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, then offset?	SteW	Excel Worksheet Functions	1	February 28th 08 02:17 PM
Lookup with offset	Mike K	Excel Worksheet Functions	6	March 21st 07 04:20 PM
Lookup and offset	Squeaky	Excel Discussion (Misc queries)	1	March 30th 06 08:34 PM
Lookup and offset	Elliott	Excel Discussion (Misc queries)	0	February 23rd 06 10:23 PM
lookup with offset?	GEORGIA	Excel Worksheet Functions	2	August 17th 05 09:28 PM

All times are GMT +1. The time now is 11:13 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us