Vlookup return #N/A but cell equal to cell return TRUE

**rzakhanov** · 04-20-2022, 04:02 AM

Hi everyone,

I have an excel file.In two different sheets have a cells

Vlookup returns #N/A but cell equal to cell return TRUE

I don't understood why?

Pls help

**Pepe Le Mokko** · 04-20-2022, 04:21 AM

Hi
please post a sample sheet ( see the yellow banner for a how-to)

**rzakhanov** · 04-20-2022, 04:29 AM

Sorry I can't here post.Because attachment not working in my computer

**Pepe Le Mokko** · 04-20-2022, 04:33 AM

There is no reason why. Just follow the wizard, do NOT use the paperclip icon
Edit you original post - Scroll down to " Manage attachments" and follow the wizard. Don't forget to click the "upload" button.

Vlookup return #N/A but cell equal to cell return TRUE

LinkBack

Thread Tools

Rate This Thread

Display

Vlookup return #N/A but cell equal to cell return TRUE

Re: Vlookup return #N/A but cell equal to cell return TRUE

Re: Vlookup return #N/A but cell equal to cell return TRUE

Re: Vlookup return #N/A but cell equal to cell return TRUE

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] formula to return true if values are opposite and Equal in Col H

[SOLVED] Return TRUE if cell contains certain “x” or numbers

[SOLVED] IF logical test pass return with 1st LOOKUP if true, if false then return with 2nd VLOOKUP

[SOLVED] Formula to always return cell below what a vlookup would return

Return all values from one call if another cell is Less than or equal to the adjacent cell

[SOLVED] cell not equal to two values, return a third value

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions