#### Silvermini63

##### Active Member

- Joined
- Sep 25, 2006

- Messages
- 293

All it is is a VLOOKUP that if the data is in B1 the return it if not C1 then return that and if it’s in D1 return that.

=IF(VLOOKUP(A1,Sheet1!A:B,2,FALSE),VLOOKUP(A1,Sheet1!A:B,2,FALSE),IF(VLOOKUP(A1,Sheet1!A:C,3,FALSE),VLOOKUP(A1,Sheet1!A:C,3,FALSE),IF(VLOOKUP(A1,Sheet1!A:D,4,FALSE),VLOOKUP(A1,Sheet1!A:D,4,FALSE))))