About Us

George A. Jululian[_2_]

Many many many Thanks

"Jacob Skaria" wrote:

Are you checking whether a record in the range Dailyreport!F:H exists in
Stock!A:C (exact match to each cell in the same row). If so the formula will
not help as it can find a value any where and not necessarily be in the same
row. If this is the requirement try the below formula which will check for a
matching record...and if found return value in Stock E9 or else would return
blank..If not please explain a bit more about your requirement

=IF(ISNA(MATCH(1,(Stock!A3:A35='Daily Report'!F21)*
(Stock!B3:B35='Daily Report'!G21)*
(Stock!C3:C35='Daily Report'!H21),0)),"",Stock!E9)

Please note that this is an array formula. You create array formulas in the
same way that you create other formulas, except you press CTRL+SHIFT+ENTER to
enter the formula. If successful in 'Formula Bar' you can notice the curly
braces at both ends like "{=<formula}"

If this post helps click Yes
---------------
Jacob Skaria

"George A. Jululian" wrote:

Hi all

please help on this formula the result if false

=IF('Daily Report'!F21=VLOOKUP(F21,Stock!A3:C35,1),IF('Daily
Report'!G21=VLOOKUP(G21,Stock!A3:C35,2),IF('Daily
Report'!H21=VLOOKUP(H21,Stock!A3:C35,3),Stock!E9)) )

Regards

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Jululian & Excel	George A. Jululian[_2_]	Excel Discussion (Misc queries)	7	November 1st 09 01:22 PM
Excel Jululian	George A. Jululian[_2_]	Excel Discussion (Misc queries)	4	October 5th 09 01:19 PM
Excel Jululian	George A. Jululian[_2_]	Excel Discussion (Misc queries)	8	February 24th 09 12:56 PM
Excel Jululian	George A. Jululian[_2_]	Excel Discussion (Misc queries)	9	February 7th 09 01:56 PM
Excel Jululian	George A. Jululian[_2_]	Excel Discussion (Misc queries)	5	December 17th 08 05:00 PM

Menu

About Us