Jululian Excel
 

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

Jululian Excel
 

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

Jululian Excel
 

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