SOLVED

Lookup a value by comparing two units

Iron Contributor

Find the Z Factor From the Cell by comparing the pressure and temperature 

2 Replies
best response confirmed by ajmal pottekattil yoousuf (Iron Contributor)
Solution

@ajmal pottekattil yoousuf 

You shouldn't type the { } around the formula. Excel will add them automatically if you confirm the formula with Ctrl+Shift+Enter to turn it into an array formula. (In Excel in Microsoft 365/Office 2021 this isn't necessary anymore). You'll have to unmerge the cell with the formula first.

See the attached version.

Thanks for the this valuable information..
1 best response

Accepted Solutions
best response confirmed by ajmal pottekattil yoousuf (Iron Contributor)
Solution

@ajmal pottekattil yoousuf 

You shouldn't type the { } around the formula. Excel will add them automatically if you confirm the formula with Ctrl+Shift+Enter to turn it into an array formula. (In Excel in Microsoft 365/Office 2021 this isn't necessary anymore). You'll have to unmerge the cell with the formula first.

See the attached version.

View solution in original post