Help with sverweis/Vlookup function

Hi Fatima

Greetings! I am Vijay, an Independent Advisor. You can use VLOOKUP very easily.

Let's say that your second list has list of items in column E (please change E appropriately). Data starts in row 2.

And first list in column A and B of same sheet. Use following formula and drag down

=VLOOKUP(E2,A:B,2,0)

More robustly

=IFERROR(VLOOKUP(E2,A:B,2,0),"")

Now there may be a scenario that first list is in Sheet1 and second list is in another sheet starting in column A.

The use following formulas

=VLOOKUP(A2,'Sheet1'!A:B,2,0)

=IFERROR(VLOOKUP(A2,'Sheet1'!A:B,2,0),"")

Hallo Lars,
<br />du hast das letzte Argument im SVERWEIS vergessen anzugeben.
<br />Ändere deine Formel ab:
<br />=IF(ISNA(VLOOKUP(C3;data;2;0));"";VLOOKUP(C3;fact_sheet.xlsx!Data;2;0))
<br />Claus
<br />

Hallo,

dann musst du nur für die Spalte einen Zähler einbauen:

With MTD

.Range("D4:M4").Formula = "=VLOOKUP(" & ID & ",Results!$A:$N,column(D4),0)"

.Range("N4").Formula = "=VLOOKUP(" & ID & ",Results!$A:$N,9,0)"

End With

Mit freundlichen Grüßen

Claus

Sure, apply a data validation list to the cells

https://support.office.com/en-us/article/apply-...

So you can setup a list for each cells and get e.g. "frog" in the cell.

Now you can setup a table and search with VLOOKUP for "frog" and return the right value. (Or you can have a 1 into a cell and use VLOOKUP to return "frog").

https://support.office.com/en-us/article/vlooku...

Andreas.

Hallo Rifz,

du kombinierst hier zwei Sprachen in einer Formel.

In einer deutschen Excel-Version lautet die Formel:

=SVERWEIS(J6;$A$2:$H$666;2;FALSCH)

In einer englischen Version:

=VLOOKUP(J6,$A$2:$H$666,2,FALSE)

Claus