|
|
#2
05-31-2020, 02:42 AM
|
||||
|
||||
Perhaps =VLOOKUP(5.52,a1:b20,2,0) ?
__________________
Using O365 v2503 - 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 |
Windows 7 64bit 
Office 2010
Threaded Mode