| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Type mismatch in look up function
hi tom, That was true.. now its working and shows the lookup value not found.. that means it cant get the value.. its there in the answer sheet and i dont know y this shows the error.. is it neccessary that the value that is to be searched and the value in the sheet should be of same format.. coz.. the value in the Answer sheet is general and the in the other sheet is number... -- bisjom ------------------------------------------------------------------------ bisjom's Profile: http://www.excelforum.com/member.php...o&userid=31206 View this thread: http://www.excelforum.com/showthread...hreadid=508799 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Type mismatch using rnge as Range with Type 8 Input Box | Excel Programming | |||
| Help: Compile error: type mismatch: array or user defined type expected | Excel Programming | |||
| Type Mismatch | Excel Programming | |||
| Type mismatch? | Excel Programming | |||
| Type mismatch in VBA LinEst function if range too large | Excel Programming | |||
![bisjom[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
