nathanthomson11
New Member
- Joined
- Apr 4, 2019
- Messages
- 23
- Office Version
- 365
- Platform
- Windows
I am looking to do do a VLOOKUP but continue going through the 'Table Array' until it finds a specific result. Unfortunately I cannot download XL2BB in the office so the best I can do is a screenshot - see attached.
In the example, I want the yellow highlighted cell in Table 3 to look up "Ford" (H3) in Table 2 BUT continue to lookup in Table 2 until it finds one of the locations in Table 1. The current formula I show will pull "729" but "729" doesn't exist in Table 1 so I want it to move onto the next "Ford" in Table 2 which is "730" because it exists in Table 1.
In the example, I want the yellow highlighted cell in Table 3 to look up "Ford" (H3) in Table 2 BUT continue to lookup in Table 2 until it finds one of the locations in Table 1. The current formula I show will pull "729" but "729" doesn't exist in Table 1 so I want it to move onto the next "Ford" in Table 2 which is "730" because it exists in Table 1.