Posted to microsoft.public.excel.programming

Norbert[_4_] Norbert[_4_] is offline

external usenet poster

Posts: 52

Lookup formula needed

I found the solution! I had to link to the cells from sheet "Warp ID." though, as the cells on sheet "Prod.ticket" are merged cells and it won't work with them.

Here is the formula (array formula) I'm using now:

=INDEX(G5:G100,MATCH(1,(B5:B100=B2)*(C5:C100=C2)*( D5:D100=D2)*(E5:E100=E2)*(F5:F100=F2),0))

the formula is to be entered with Ctrl+Shift+Enter

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 Formula Needed	sweetmans	Excel Discussion (Misc queries)	2	January 22nd 10 08:16 PM
Lookup Formula Needed	Deepak	Excel Discussion (Misc queries)	3	December 29th 08 09:05 PM
Complicated lookup/match formula help needed!	Jason[_11_]	Excel Worksheet Functions	2	March 21st 08 12:39 AM
Lookup in Two Columns, Help needed with formula	charles	Excel Worksheet Functions	10	October 16th 06 11:17 PM
LOOKUP Formula help needed	Weasel	Excel Discussion (Misc queries)	1	March 21st 06 10:13 PM

All times are GMT +1. The time now is 08:37 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us