Sverweis

%3CLINGO-SUB%20id%3D%22lingo-sub-2441939%22%20slang%3D%22de-DE%22%3EReference%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2441939%22%20slang%3D%22de-DE%22%3EI%20have%20a%20list%20of%20names%20that%20should%20be%20searched%20not%20only%20in%20one%2C%20but%20in%20two%20other%20tables%20with%20the%20help%20of%20the%20S%20reference.%20Problem%20is%20that%20he%20automatically%20pulls%20me%20as%20soon%20as%20I%20make%20e.g.%20the%20sverweis%20with%20table%201%2C%20he%20automatically%20pulls%20me%20into%20all%20other%20cells%20although%20I%20want%20to%20make%20the%20sverweis%20from%20cell%20xyz%20with%20table%202.%20How%20can%20I%20set%20it%20to%20continue%20the%20reference%20only%20for%20the%20cells%20I%20select%20instead%20of%20the%20complete%20column%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2441939%22%20slang%3D%22de-DE%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2442157%22%20slang%3D%22en-US%22%3ERe%3A%20Sverweis%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2442157%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1077403%22%20target%3D%22_blank%22%3E%40Giuliana1493%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20an%20example%20with%20three%20(3)%20criteria.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20Community%20members%20reading%20here%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
Ich habe eine Liste mit Namen die nicht nur in einer, sondern in zwei anderen Tabellen mit Hilfe des S Verweises gesucht werden sollen. Problem ist, dass er mir automatisch sobald ich zb den sverweis mit Tabelle 1 mache, er mir den automatisch in alle anderen Zellen mitzieht obwohl ich ab Zelle xyz mit Tabelle 2 den sverweis machen möchte. Wie kann ich einstellen dass er den sverweis nur für die Zellen fortführt die ich auswähle statt für die komplette Spalte?
1 Reply

@Giuliana1493 

Here is an example with three (3) criteria.

 

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here