how to modify the fomular to look up two sheets?

D

Dandan Zhu

=IF(A7="","",-IF(HLOOKUP($A7,Calculation!$C$1:$HJ$801,801,FALSE)=1,0,J7*R7*I7*Q7/O7/100))

It looks up Calculation sheet at the moment, I want to look up both Calculation sheet and Calculation sheet 2.

Many thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with Excel Cross Reference Formula 0
Populating data to right based upon cell criteria 1
How to list cells from two sheets that has different values in theirneighboring column? 8
Conditional Formatting to Compare Two Sheets of Data 1
Unhide sheet, copy and rename new sheets from list, rehide sheet 8
How to modify and updte specific styles for specific paragraphs across the document 0
Looking up a Cell and returning correspong Cell value 0
Compare two different workbook sheet to show the difference in text 0

Top