| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can someone tell me what this formula means?
I'm trying to decipher a progam but don't know what this is saying:
=IF(ISERROR(VLOOKUP($C17,'6'!$B$1:$E$25,4,0))=TRUE ,"",VLOOKUP($C17,'6'! $B$1:$E$25,4,0)) I understand that it's doing a VLOOKUP of what's in cell $C17, but the '6' part attached to the table is throwing me off. Also, does the =TRUE thing mean I'm NOT looking for an exact match? Can anyone put this into English for me? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can anyone tell me what this formula means? | Excel Discussion (Misc queries) | |||
| what it means in a range (B:B) | Excel Discussion (Misc queries) | |||
| hi i would like to know what this means } | New Users to Excel | |||
| want to know what error I/O 32. means please | Excel Discussion (Misc queries) | |||
| " " means in IF function | Excel Discussion (Misc queries) | |||
Threaded Mode
