Microsoft Office Forums - View Single Post - formula reference Problem

Thread: formula reference Problem

View Single Post

Old

05-31-2020, 05:15 AM

nsbns

nsbns is offline

nsbns uses Windows 7 32bit

Windows 7 32bit nsbns uses Office 2019

nsbns uses Office 2019

Office 2019

Novice

The original poster

Join Date: May 2020

Posts: 2

nsbns is on a distinguished road

Default

Quote:

Originally Posted by Pecoflyer

View Post

Perhaps =VLOOKUP(5.52,a1:b20,2,0) ?

had tried the formula but the value reference is 21 not 96 as there are other 5.52 numbers at col a

Reply With Quote