| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup
i need a formula that will look up a word then give me the numbers in a cell
next to that word. the formula i'm using (which isn't working right) is =IF(ISERROR(VLOOKUP(A6,'Export 1'!$B$1:$Z$65467,11,FALSE)),"",VLOOKUP(A6,'Export 1'!$B$1:$Z$65467,11,FALSE)) this may be too much formula for what i need but i'm not sure... here's what i'm actually trying to do. i would like to set up a check list or something so when people select a certain row by adding a X, the following information will auto fill onto another sheet... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If (Vlookup 0) working, but what if Vlookup cell does not exist | Excel Worksheet Functions | |||
| Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
| Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
| Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Threaded Mode
