SOLVED

# Lookup a value by comparing two units

Occasional Contributor

# Lookup a value by comparing two units

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

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

# Re: Lookup a value by comparing two units

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.

# Re: Lookup a value by comparing two units

Thanks for the this valuable information..