| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Look Up Function
I have a table set up so that a user can key in one number and it flood in
the rest of her information based on a table that I have set up on another worksheet. The formula works fine if the exact number is keyed in. However, if she keys in the wrong number, it still pulls information. How can I make it pull over only if the data is exact? This is the formula that I have: =LOOKUP('Data Entered In'!A2,'Data Table'!$A$2:$A$49,'Data Table'!$A$2:$A$49) -- Thanks a bunch! rojobrown |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date & Time | New Users to Excel | |||
| Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
| Conversion | Excel Worksheet Functions | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
| Find a Function to use accross different worksheets | Excel Worksheet Functions | |||
Threaded Mode
