Microsoft Excel vlookup formula
Arun
I have two sheets as below.
Sheet1:
Sno Emp ID Name Address 1 101 X. ? 2 01 Y. ?
Sheet2:
Sno Emp ID Name Address 1 10 D. XX 2 101 X. YY
I need that address in Sheet2 in Sheet1 address column.
Please help me out.
ejbytes
If you want the Home Address of the Employee:
Use the:
VLOOKUP( lookup ref, table ref search, result col, match )
= vlookup(B2, table-sheet2, 2nd column, exact match)
= vlookup(employee ID 101, table on sheet2, Name, exact match)
C2: Name Search, referencing the Employee ID, to TABLE
=VLOOKUP(B2,Sheet2!$B$2:$D$5,2,FALSE), for Name Search ref, Emp.ID
D2: Address Search, referenceing the Employee ID, to TABLE
=VLOOKUP(B2,Sheet2!$B$2:$D$5,3,FALSE)
Note: It's necessary to use the static notation $B$2:$D$5 for copy/paste functionality so that you can paste the formula to the cells in the column; else if you use dynamic notation B2:D5, the next cell will search B3:D6, then B4:D7, and so on, and that's unintended. The TABLE must be in, it is assumed by EXCEL, alphabetical/numeric order!
이 기사는 인터넷에서 수집됩니다. 재 인쇄 할 때 출처를 알려주십시오.
침해가 발생한 경우 연락 주시기 바랍니다[email protected] 삭제
에서 수정
관련 기사
Related 관련 기사
- 1
Microsoft Excel vlookup 공식
- 2
Microsoft Excel vlookup 공식
- 3
Microsoft Excel Conditional String Output Formula
- 4
VLOOKUP a HYPERLINK formula
- 5
Microsoft Excel에서 vlookup / hlookup하는 방법은 무엇입니까?
- 6
Microsoft Excel에서 vlookup / hlookup하는 방법은 무엇입니까?
- 7
Excel VLOOKUP + SUMPRODUCT for multiple
- 8
Excel - VLookup Example
- 9
Excel Vlookup 날짜,
- 10
Excel VBA의 Vlookup
- 11
VBA Excel VLookup
- 12
Excel Vlookup 지원
- 13
Excel 결합 Vlookup
- 14
Excel VLOOKUP 문제
- 15
Trouble using "HLOOKUP" in Microsoft Excel 2010. Sometimes formula generates an error
- 16
Microsoft Excel 2007-Vlookup 용 동적 Table_Array를 작성하는 방법
- 17
EXCEL SUMPRODUCT FORMULA
- 18
Nested IF formula in Excel
- 19
Replicating a formula pattern in Excel
- 20
Excel-Vlookup 문제
- 21
Excel의 VLOOKUP 기능
- 22
Excel의 Vlookup 수식
- 23
Excel VBA code for multiple vlookup
- 24
2 열로 Excel VLOOKUP
- 25
Excel 2010 : VLOOKUP 함수
- 26
Excel formula for inline (in formula only) lookup
- 27
Creating Formula (Effective-Discontinue) Dates while using vlookup
- 28
VBA .Formula Vlookup with Wildcard Returning Type Mismatch (Simple)
- 29
Excel Multiple Cells Included in an IF Formula
몇 마디 만하겠습니다