Return value if there is an #N/A error

[mattbnorris]

Okay so I have a list of numbers that will be pasted next to an already placed VLOOKUP function, this VLOOKUP will lookup the numbers pasted in another list. This means the VLOOKUP returns a list of all the numbers that already exist in the 'lookup list' and then #N/A if a new number is there. I want a formula that returns those new numbers... for example

'Lookup list' Pasted VLOOKUP New (formula I'm looking for)
#245 #245 #245 #233
#267 #233 #N/A #288
#244 #267 #267
#235 #244 #244
#266 #288 #N/A
#235 #235
#266 #266

Thanks,
Matt

 

[mattbnorris]

'Lookup list' Pasted VLOOKUP New (formula I'm looking for)
#245 #245 #245 #233
#267 #233 #N/A #288
#244 #267 #267
#235 #244 #244
#266 #288 #N/A
#235 #235
#266 #266

The spaces aren't showing in the original query

 

[mattbnorris]

[TABLE="width: 500"]
<tbody>[TR]
[TD]'Lookup list'[/TD]
[TD]Pasted[/TD]
[TD]VLOOKUP[/TD]
[TD]New (formula needed)[/TD]
[/TR]
[TR]
[TD]#245[/TD]
[TD]#245[/TD]
[TD]#245[/TD]
[TD]#233[/TD]
[/TR]
[TR]
[TD]#267[/TD]
[TD]#233[/TD]
[TD]#N/A[/TD]
[TD]#288[/TD]
[/TR]
[TR]
[TD]#244[/TD]
[TD]#267[/TD]
[TD]#267[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]#235[/TD]
[TD]#244[/TD]
[TD]#244[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]#266[/TD]
[TD]#288[/TD]
[TD]#N/A[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]#235[/TD]
[TD]#235[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]#266[/TD]
[TD]#266[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Apologies, should have done a table to start.

 

[Peter_SSs]

Try this, copied down.

Excel Workbook
	A	B	C	D
1
2	#245	#245	#245	#233
3	#267	#233	#N/A	#288
4	#244	#267	#267
5	#235	#244	#244
6	#266	#288	#N/A
7		#235	#235
8		#266	#266
9
new numbers

 

[mattbnorris]

That is amazing! Thank you

 

[Peter_SSs]

That is amazing! Thank you

Glad it worked for you. Thanks for the follow-up.