Posted to microsoft.public.excel.worksheet.functions

Shell

external usenet poster

Posts: 32

Offset formula

This is an example of the formula I am working on at the moment.
=OFFSET('JOB '!$B$20,MATCH("HD0474",'JOB '!$B$21:$B$38, 0),1)

If I want it to look up the part above (HD0474), but instead of typing it in
each time, get the information from the field A38 on the same sheet, how do I
do this?

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
Offset Formula	Secret Squirrel	Excel Discussion (Misc queries)	3	July 28th 08 12:48 AM
Compare Cell Values, Offset(-1,0), Offset(-1,-1), and xlFillDefaul	RyGuy	Excel Worksheet Functions	2	September 28th 07 10:54 PM
1 OFFSET FORMULA, I'M NOT SURE WHAT DOES IT MEAN!!!!!!	HERNAN	Excel Discussion (Misc queries)	2	July 9th 07 07:41 PM
Help with Offset formula	Ken G.	Excel Discussion (Misc queries)	2	May 26th 06 02:32 AM
Offset formula	richy	Excel Worksheet Functions	8	January 6th 06 09:27 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us