Forum Discussion
Asha1232185
Feb 20, 2024Copper Contributor
index & match formular in two sheets
want to apply formula
HansVogelaar
MVP
Please help us to help you by providing more detailed information.
Asha1232185
Feb 20, 2024Copper Contributor
Have to match Subcriber name from two sheet but the response is ROW no whereas expectation is to get the name from particular field
- HansVogelaarFeb 20, 2024MVP
Let's say the sheets are named Sheet 1 and Sheet 2.
On Sheet 1, you have subscriber names in A2, A3, etc., and the value you want to look up in D2, D3, etc.
On Sheet 2, you enter a subscriber name in B2.
Enter the following formula in (for example) C2:
=IFERROR(INDEX('Sheet 1'!$D:$D, MATCH(B2, 'Sheet 1'!$A:$A, 0)), "")
or
=XLOOKUP(B2, 'Sheet 1'!$A:$A, 'Sheet 1'!$D:$D, "")
The formula can be filled down.