Shockwave IIC
New Member
- Joined
- Jun 19, 2015
- Messages
- 31
Afternoon
Trying to get a cell to return different messages based on if a Vlookup gets a return or not
Ie,
Vlookup in Cell G8 returns a result - B8 gives instructions on what to do next (Text in cell A13)
Vlookup in Cell G8 returns #N/A result (Failed return) - B8 gives different instructions (Text in Cell A11)
currently trying this
if(G8="#N/A",A11,A13)
Trying to get a cell to return different messages based on if a Vlookup gets a return or not
Ie,
Vlookup in Cell G8 returns a result - B8 gives instructions on what to do next (Text in cell A13)
Vlookup in Cell G8 returns #N/A result (Failed return) - B8 gives different instructions (Text in Cell A11)
currently trying this
if(G8="#N/A",A11,A13)