| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup Table
You're welcome - thanks for feeding back.
Pete "empire11" wrote in message ... Yep...that works. I've only ever used lookups where I'm looking for the exact number so alway put =VLOOKUP(A1,M1:N5,2,FALSE) so that it would return an #N/A if it couldn't find an exact match. All sorts of possibilities now...thanks Pete! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup Value in Table | Excel Worksheet Functions | |||
| Lookup data in a variable table & retrieve data from a pivot table | Excel Worksheet Functions | |||
| Lookup table help please | Excel Discussion (Misc queries) | |||
| Lookup Table help | Excel Worksheet Functions | |||
| Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
Hybrid Mode
