| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
nearest match
I have in sheet 1 cell U1 1040
U2 1120 U3 1212 U4 1320 U5 1600 U6 2070 in sheet 2 i have cell F1 1010 G1 58.32 F2 1030 G2 59.29 F3 1050 G3 61.32 F4 1110 G4 64.30 F5 1140 G5 66.05 F6 1200 G6 70.10 F7 1350 G7 79.63 F8 1615 G8 96.93 I need sheet 1 U1 nearest match up or down compared to sheet 2 column F and return the corresponding number in column G eg: if sheet 1 U1 is 1040 use sheet 2 F2 1030 return G2 59.29 U2 is 1120 use sheet 2 F4 1110 return G4 64.30 U4 is 1320 use sheet 2 F7 1350 return G7 79.63 U5 is 1600 use sheet 2 F8 1615 return G8 96.93 -- Can any one help please Thanks bill gras |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match Index | Excel Worksheet Functions | |||
| Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
| Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
| Find a match that;s not exact | Excel Worksheet Functions | |||
| Vlookup, Index & Match | Excel Worksheet Functions | |||
Threaded Mode
