Simple Vlookup not working

		Microsoft Office Forums > Microsoft Excel > Excel
Simple Vlookup not working

FAQ

Thread Tools

Display Modes

03-21-2019, 09:56 PM

xor

Windows 10 Simple Vlookup not working

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,103

All of

=IF(VLOOKUP($B2,Sheet2!$A1:$AX10,26,0)="","","X")
=IF($B2="","",IF(ISBLANK(VLOOKUP($B2,Sheet2!$A:$GF ,26,FALSE)),"","X"))
=IF(ISERROR(VLOOKUP($B2,Sheet2!$A:$AX,26,FALSE))," ","X")

works fine for me.

Edit: Wasn't aware that the problem had been solved.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Vlookup Not working Properly	josepfh	Excel	1	04-19-2017 11:04 AM
Conditional formatting not working with simple formula	bendmc	Excel	2	11-17-2016 11:31 AM
VLOOKUP not working properly with data digiting, only copy&paste	Mike84bs	Excel	3	05-06-2015 10:01 AM
VLOOKUP Formula is not working	babs1234	Excel	3	03-04-2015 06:08 AM
vlookup not working	jolinchew	Excel	3	08-10-2013 05:24 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:41 PM.