vlookup in vba

I am looking to "pre"populate a ComboBox for the user with some data. The 1st step is to utilize a Vlookup that takes the current date and chooses a shift letter (A or C) that is on a non-activated sheet.. The below code gives me a runtime error 1004 on the Vlookup line Sub...

Trying to look up a value within a range using vlookup. If the value doesn't exist, then I want it to return either 0, nothing etc Then I can use an if statement on the variable, so that if it IS nothing then I can do something (add the missing value to the end of a range) test =...

I am having a hard time figuring out how to convert my VLookup formula I have in my cells to a VBA format. Here is the code that I have in my Cells and I need to convert to VBA form. =IF(ISNA(VLOOKUP($C4&" "&U$3,LMSDTU,18,FALSE)),"",VLOOKUP($C4&" "&U$3,LMSDTU,18,FALSE)) Your help is greatly...

I'm a newbie at VBA and trying to learn how to get a macro to fill out a list for me. I keep running into errors. Here's what I'm trying to do: I have 2 worksheets: Names and Data Names is a worksheet with multiple data validation boxes Data is a list of all those names with counts of how...

Hi There! I have a workbook where I need a cell to be populated in an array of worksheets I specfiy, with below function: =IF(ISNA(VLOOKUP($C$3&" * ",'Y:\ttd\January 2010\[Jan_costs.xlsx]revdata'!$A$11:$AA$1239,5,0))=TRUE,"",VLOOKUP($C$3&" * ",'Y:\ttd\January...

Hi all: It has been some time since I have posted. I just can't seem to stay within my comfort zone with excel. I have 2 sheets named "Input" and "ActivityOffset". The sheets are set up as follows: Input Sheet Column A: Activity/Offset Codes. This column is validated by the named range "AO"...