formula reference Problem

		Microsoft Office Forums > Microsoft Excel > Excel
formula reference Problem

05-31-2020, 05:15 AM

nsbns

Windows 7 32bit formula reference Problem

Office 2019

Novice

Join Date: May 2020

Posts: 2

Quote:

Originally Posted by Pecoflyer

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to reference a named range in a different file within a formula	Brock297	Excel	1	10-25-2018 08:50 AM
I am trying to cross reference data, and I need the right formula.	Ninphysics	Excel	1	05-16-2018 02:34 AM
some reference formula issues.	OmerGassner	Excel	1	02-23-2017 08:42 AM
Formula for reference last non empty cell in row	npn321	Excel	10	02-22-2017 11:42 PM
Need help with dragging a formula and changing a reference column as I drag the formula.	LupeB	Excel	1	10-22-2015 03:02 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:20 PM.