=vlookup(A1,B2:B10,1 ,0)
A1 is the cell you want to check
B2:B10 is the range where you think A1 exists
The rest is just standard
Posted By: Vivid Data Shark, Jul 29, 16:11:14
Follow Ups
- 1You'll need to look the range down by doing the following
Posted By: CityForLife, Jul 29, 16:44:47 - Cheers
Posted By: Yellalee, Jul 29, 16:20:40
Reply to Message
Written & Designed By Ben Graves 1999-2025