Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-30-2020, 08:40 PM
nsbns nsbns is offline formula reference Problem Windows 7 32bit formula reference Problem Office 2019
Novice
formula reference Problem
 
Join Date: May 2020
Posts: 2
nsbns is on a distinguished road
Default formula reference Problem

have a col a and col b data

5.65 25
5.52 21
5.51 26
5.25 55
5.21 65
5.26 95
5.51 69
5.52 98
5.55 68
5.52 96
5.66 92
5.95 95

and wan to reference col b data 96 from col a 5.52



anYone has a formula to reference 96? tried alots of waYs to reference 96 from 5.52 but not valid
Reply With Quote
  #2  
Old 05-31-2020, 02:42 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline formula reference Problem Windows 7 64bit formula reference Problem Office 2010
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,420
Pecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to all
Default

Perhaps =VLOOKUP(5.52,a1:b20,2,0) ?
Reply With Quote
  #3  
Old 05-31-2020, 05:15 AM
nsbns nsbns is offline formula reference Problem Windows 7 32bit formula reference Problem Office 2019
Novice
formula reference Problem
 
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
  #4  
Old 05-31-2020, 11:32 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline formula reference Problem Windows 7 64bit formula reference Problem Office 2010
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,420
Pecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to all
Default

If you are seraching for the last corresponding value try
=LOOKUP(2,1/(A1:A12=5.52),B1:B12)
Reply With Quote
Reply

Thread Tools
Display Modes


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 reference Problem 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 - Senior Forums

All times are GMT -7. The time now is 09:42 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft