iansammcluckie
New Member
- Joined
- Jul 21, 2010
- Messages
- 4
Hi.
I am using the following vlookup:
=VLOOKUP(LEFT($A2,8)&"*",Dashboard_EA!$A$199:$P$213,5,0).
When the formula is not finding a value, it is returning #N/A.
I wish to replace this #N/A with "NO DATA".
Please advise me on how I should write the formula.
Thank you.
I am using the following vlookup:
=VLOOKUP(LEFT($A2,8)&"*",Dashboard_EA!$A$199:$P$213,5,0).
When the formula is not finding a value, it is returning #N/A.
I wish to replace this #N/A with "NO DATA".
Please advise me on how I should write the formula.
Thank you.