Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can the IF function be used with values from multiple worksheets?
Hi! I have 2 worksheets. I am trying to get an equation that will match values between worksheets and then fill in another column with data from the opposite worksheet. My IF equation right now is:
=IF(B2='[ms updated inventory with ahfs.xls]ICu'!$A$2,L2='[ms updated inventory with ahfs.xls]ICu'!$B$2) Where B2 is value on worksheet a, ms updated inventory with ahfs.xls]ICu'! this is the match to column in worksheet b A2 is the cell to place the new information and L2 is where to get the info to place in A2. If they do not match, I want the A cell to be left blank. I hope this makes sense...this is my first post. I appreciate any help you can provide. Tricia |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seperate values into multiple worksheets | Excel Worksheet Functions | |||
sumproduct multiple values on other worksheets | Excel Worksheet Functions | |||
Average Values / Multiple Worksheets | Excel Worksheet Functions | |||
Footer values on multiple worksheets | Excel Discussion (Misc queries) | |||
How to sum values in multiple worksheets | Excel Worksheet Functions |