Lookup a value by comparing two units

Occasional Contributor

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

3 Replies
best response confirmed by ajmal pottekattil yoousuf (Occasional Contributor)

@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..