Jululian Excel

  • Thread starter Thread starter George A. Jululian
  • Start date Start date
G

George A. Jululian

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
 
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
 
Many many many Thanks

Jacob Skaria said:
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
Click to expand...
 
Back
Top