Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF, INDIRECT, & Wild cards
I have the following formula in a worksheet cell that captures data from
another worksheet: =IF(INDIRECT("'"&$T$1&"'!" & "h"&$N37) = "*U*", INDIRECT("'"&$T$1&"'!" & "h"&$N37), VALUE(INDIRECT("'"&$T$1&"'!" & "h"&$N37))) This works great if there is no "U" in the referred to cell because a number is returned but if there is a "U" in the referred to cell, #VALUE! is returned! If I just use =INDIRECT("'"&$T$1&"'!" & "h"&$N37), it works fine whether there is a "U" or not in the referred to cell, e.g., 10U will be returned but a 50 will be returned as text and I need a number if there is no "U". Hence, my need for the IF statement. The referred to cells come from an Access database query where I had to combine two fields to create one field for Excel. Does anyone have an idea of what I may be doing wrong? TIA -- javablood |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EXCEL Wild Cards | New Users to Excel | |||
Wild Cards with IF stmt | Excel Worksheet Functions | |||
wild cards? | Excel Discussion (Misc queries) | |||
wild cards in SUMIF | Excel Worksheet Functions | |||
If Statement Using Wild Cards | Excel Worksheet Functions |