cardminger
New Member
- Joined
- Nov 10, 2021
- Messages
- 1
- Office Version
- 2019
- 2016
- 2013
Hey guys!
I am working on a sheet to do rolling purchase orders and here is what I am trying to accomplish -
I would like VLOOKUP to find the first match in another sheet where a certain condition is met. So essentially -
Lookup first value for SKUXYZ, if found, check column C, if column C is "False" - find the next value that matches SKUXYZ. If column C is "True", return the value for the VLOOKUP.
Is something like this possible?
I am working on a sheet to do rolling purchase orders and here is what I am trying to accomplish -
I would like VLOOKUP to find the first match in another sheet where a certain condition is met. So essentially -
Lookup first value for SKUXYZ, if found, check column C, if column C is "False" - find the next value that matches SKUXYZ. If column C is "True", return the value for the VLOOKUP.
Is something like this possible?