#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
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 |
#3
|
|||
|
|||
had tried the formula but the value reference is 21 not 96 as there are other 5.52 numbers at col a
|
#4
|
||||
|
||||
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 |
|
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 |