Possible vlookup?
I’m trying to work a formula that will check if a value in one column on sheet one matches a value in another column on sheet two and if so, I need it to display the value in another column on sheet 2. Is that possible?
Sheet 1 = list
Sheet 2 = data
If Sheet 1 column 1 (amount) = sheet 2 column 2 (amount), display sheet 2 column 3 (reference) of the matching row.
hope this makes sense?
Answers
-
Move column 2 in sheet 2 to column 1, then you can use the formula below:
=VLOOKUP([Sheet1Column1]@row, {Column 1 to 3 Range from Sheet 2}, 3, false)
-
Thanks, it’s giving me a formula parse error?
-
Hi @eLIZo,
Here's an example of a working VLOOKUP formula that you may use for your reference:
Formula and results:
Vlookup table used in cross-sheet reference:
I hope that this can be of help.
Cheers!
Julio
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!