| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
#VALUE! displayed when referencing a formula cell
I'm using a IF,ISNA,VLOOPUP string in a cell to obtain a price from a seperate sheet. However, a seperate cell is set to perform a calculation on this number that is obtained from the above string. The problem is that unless the user has entered the required text to enable the vlookup to obtain the figure, the other column just lists #value! all the way down... How do i get it to display and empty cell... I suspect that it's caused by excel attempting to calculate a result from a formula.. or it that incorrect. To summarise as an example Cell A1, the user enters a search string Cell A2, contains a Vlookup to search based on A1 Cell A3, contains a calculation that is to be performed on A2 Problem, Where A1 (and therefore A2) dont contain data, A3 displays #VALUE! cheers in advance barry -- bazza825 ------------------------------------------------------------------------ bazza825's Profile: http://www.excelforum.com/member.php...o&userid=33241 View this thread: http://www.excelforum.com/showthread...hreadid=537382 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| need help referencing cell using result of formula | Excel Discussion (Misc queries) | |||
| Deferring conditional formatting? | Excel Discussion (Misc queries) | |||
| Referencing text in a cell in a formula | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Threaded Mode
