Forum Discussion
VLOOKUP
I need a formula to pull associated data from one sheet to another sheet. Ex: Sheet 1 has Transaction ID. Sheet 2 has a Transaction ID and a User ID. I need to only pull in certain User IDs from Sheet 2 associated with certain Transaction IDs in Sheet 1. Screen shot below.
1 Reply
In B2:
=IFERROR(VLOOKUP(A2, 'SHEET 2'!$A$2:$B$1000, 2, FALSE), "")
Fill down.
If you have a recent version of Excel, enter the following formula in B2. It will spill to B2:B6.
=XLOOKUP(A2:A6, 'SHEET 2'!A2:A1000, 'SHEET 2'!B2:B1000, "")
Change SHEET 2 to the real name of that sheet.
