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,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Perhaps =VLOOKUP(5.52,a1:b20,2,0) ?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
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,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

If you are seraching for the last corresponding value try
=LOOKUP(2,1/(A1:A12=5.52),B1:B12)
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
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

All times are GMT -7. The time now is 02:46 PM.


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