Excel - VLOOKUP formula

I am using a VLOOKUP formula in a sheet that is used for Employee Data Entry.
I have used it so that I do not have to enter the Employer and Trade once I
pick an employee from a drop down box.

The formula works when I have selected an employee from the list but when
the cell (say I2) the formula in cell J2 & K2 show up as #N/A until I have
selected an employee.

I need this not to show up becuase it is stuffing up the rest of my formulas
and calculations for the wages.

The formula that I have used is :
=VLOOKUP(I8,'Employee''s'!$B$2:$J$999,2,FALSE)
So the way the I worked it is if I8 equals anything in B2:J999 it shows the
value in row 2 of my employee table on the Employee worksheet but it shows
the #N/A if anything I8 is blank.

  Mike replied...

Try,

=IF(I8="","",VLOOKUP(I8,'Employee''s'!$B$2:$J$999,2,FALSE))

Mike

  Ralli replied...

Hi Mike,

Thanks for the reply.

I copied the formula over and it gets ride of the #N/A but it the will not
show up the information from row 2 for who his employer is.

Cheers.
Ral

  Mike replied...

Hi,

The only thing I changed in your formula was the sheet name, to save me
creating a sheet of that name. Check I've put it back in correctly. Also
check your data for rogue spaces.

Mike

Vlookup Encounters a call with no data and returns #N / A Excel My vlookup formula goes like this = VLOOKUP($A2, December!$C$3:$H$68, 3, FALSE)+VLOOKUP($A2, January!$C$3:$H$65, 3, FALSE)+VLOOKUP($A2, February!$C$3:$H$74, 3, FALSE)+VLOOKUP($A2, March!$C$3:$H$85, 3, FALSE VLOOKUP($A2, April!$C$3:$H$85, 3, FALSE) The formula finds a name an adds of the months like April do not have the names of the people so the vlookup returns #N / A instead of the sum, because that name could not be found in

Macro ' Macro enregistr = E9e le 29 / 04 / 2003 par Christophe Application.ScreenUpdating = 3D False ' Unprotect Worksheet ActiveWorkbook.Unprotect Password: = 3D"* ** **" Worksheets("Company Data").Select ' save last changes made at Worksheet "Country Appointments" Worksheets("Country Appointments").Select 'ActiveSheet.Unprotect Password: = 3D"* ** **" Cells.Select Cells.EntireColumn.AutoFit AutoFit 'Run macro "SwapTableShowtime" Range is automaticaly selected 'Then result is saved into "Company Appointments" worksheet and cell A1 is filled with Date / Time label ActiveSheet.Name = 3D "Transitory1" Columns("A Replacement: = 3D"", LookAt: = 3DxlPart, _ SearchOrder: = 3DxlByRows, MatchCase: = 3DFalse 'Copy and paste result into "Transitory2" worksheet Cells.Select Application.CutCopyMode = 3D False Selection.Copy Range("A1").Select Sheets.Add.Name = 3D exceed 120 please increase number in macro) 'to copy the first two columns of "Transitory2" worksheet and paste it each time in a new sheet 'named by the company name in 3D xlNone Selection.Borders(xlInsideVertical).LineStyle = 3D xlNone Range("C16").Select ActiveCell.FormulaR1C1 = 3D _ (VLOOKUP(RC[-1], CountryData, 2, FALSE)))" Range("C16").Select Selection.Copy Range("C17:D47").Select Selection SkipBlanks: = 3DFalse, Transpose: = 3DFalse Application.CutCopyMode = 3D False Range("D16").Select ActiveCell.FormulaR1C1 = 3D _ (VLOOKUP(RC[-2], CountryData, 3, FALSE)))" Range("D16").Select Selection.Copy Range("D17:D47").Select Selection LineStyle = 3D xlNone Selection.Borders(xlInsideVertical).LineStyle = 3D xlNone Range("A3").Select ActiveCell.Formula = 3D (VLOOKUP(B13, COMPANY2, 14, FALSE)))&"" (VLOOKUP(B13, COMPANY2, 15, FALSE)))&"" (VLOOKUP(B13, COMPANY2, 16, FALSE)))" Selection

vlookup Excel Hello to all, I have the archives excel with 12 sheets with data and a 13° for the totals. I have used in 13° the sheet in several columns vlookup+ vlookup+ +vlookup+ . . . . . . . . . . . . . . in order to add the data of the 12 sheets precedence. The formula has become the formula need modified manually. It's possible to insert simple macro that functions like vlookup that controls l' heading of column of 13° the sheet and verifies in the twelve 05 0, 07 0, 09 0, 11 . . . . . . . . . . . . . . . . . . . . . Sheet 13 cod val1 val2 val3 val4 A = VLOOKUP(. . . . )+ = VLOOKUP(. . .)+VLOOKUP(. . .)+VLOOKUP(. . .)+. . . . . . . . . . . . . . . . . B = VLOOKUP(. . . . )+ = VLOOKUP(. . .)+VLOOKUP(. . .)+VLOOKUP(. . .)+. . . . . . . . . . . . . . . . . C = VLOOKUP(. . . . )+ = VLOOKUP(. . .)+VLOOKUP(. . .)+VLOOKUP(. . .)+. . . . . . . . . . . . . . . . . D = VLOOKUP(. . . . )+ = VLOOKUP(. . .)+VLOOKUP

Search one worksheet to pull data into another worksheet Excel Worksheet 1: Name Acct Symbol Desc Qty Price Value Smith 614 FDRXX Fid Cash 33.66 42.85 12524.67 Jones 188 FCNTX Fid Contra 273.98 42.85 11739.96 Worksheet 2: I would like to first search Worksheet 1 for all instances of acct 188 which can appear anywhere in column 2, (in down to one result, and return Fid Contra 273.98, 42.85, and 11739.96. Worksheet 1 always has the same columns but in random order. It can be sorted but a unique acct number, so Jones is always 188. I've tried Lookup, Match, If, VLookup all with some limited success but not really getting what I want. If someone can I should be using, it would be helpful. Thanks very much in advance. - Barbara Excel Worksheet Discussions Worksheet (1) INDEX (1) MATCH (1) ROW (1) MAX (1) Report (1) Hi, Enter

sub pu = F2 essere scritta molto meglio cos = EC: Public Sub m() Dim sh1 As Worksheet Dim sh2 As Worksheet Set sh1 = 3D ThisWorkbook.Worksheets("Foglio1") Set sh2 = 3D ThisWorkbook.Worksheets("Foglio2") sh1.Range("A1 un valore: Private Sub CommandButton1_Click() 'dichiaro le variabili Dim wk As Workbook Dim sh2 As Worksheet Dim lNuovaRiga As Long 'metto un riferimento al Workbook 'che contiene la macro Set wk fogli, quindi renderli visibili, sin qui inserisco le righe Private Sub CommandButton3_Click() Dim sh2 As Worksheet Set sh2 = 3D ThisWorkbook.Worksheets("Foglio2") sh2.Visible = 3D xlSheetVeryHidden = 3D -1 Set sh2 = 3D due pulsanti: Private Sub CommandButton1_Click() 'dichiaro le variabili Dim wk As Workbook Dim sh As Worksheet 'metto un riferimento al workbook 'che contiene il codice Set wk = ThisWorkbook With wk 'ciclo End Sub Private Sub CommandButton2_Click() 'dichiaro le variabili Dim wk As Workbook Dim sh As Worksheet 'metto un riferimento al workbook 'che contiene il codice Set wk = ThisWorkbook With wk 'ciclo due cose: Private Sub CommandButton3_Click() 'dichiaro le variabili Dim wk As Workbook Dim sh As Worksheet 'metto un riferimento al workbook 'che contiene il codice Set wk = ThisWorkbook With wk 'ciclo dichiaro le variabili visibili 'da tutta la UserForm Private wk As Workbook Private sh1 As Worksheet Private sh2 As Worksheet Private sh3 As Worksheet Private Sub Frame2_Click() End Sub 'questo ? l