Forum Discussion
helsbrooks1981
Apr 21, 2021Copper Contributor
VLook up help
Hi - I have a vendor spendsheet on Sheet1. On Sheet1 I have just the vendor number but would like the vendor name as well - taken from Sheet2. I have very basic Vlookup skills and its just returni...
- Apr 21, 2021
helsbrooks1981 The vendor number on Sheet1 are in fact texts, whereas they are real numbers on Sheet. On top of that, you switched some of the arguments in the VLOOKUP formula.
Fixed that in the attached file. See if this is what you expect.
helsbrooks1981
Apr 21, 2021Copper Contributor
Thank you very much that works
Riny_van_Eekelen
Apr 21, 2021Platinum Contributor
helsbrooks1981 You're welcome!