Vlookup formula isn't working (and I don't know why.)

[HizExceLenCy]

I'm a flight simulator pilot, (which will help to explain the nature of the spreadsheets when you see them.)

Anyway, I followed "Computergaga"'s tutorial on the web, which I found to be very good. However, even though I followed his instructions to the letter, it always returned a value of "N/A" even though both items were on both sheets, clear as day.

What I'm using VLOOKUP for is to determine if everything in Column "A" in Sheet one is also in Column "A" in Sheet 2. (which I reorganized, via panel.)


I'm using Windows 10
Excel 2010

Here's the Computergaga video.

I would have uploaded the workbook but I don't know how...

HizExcelenCy

 

[sandy666]

maybe it will help: https://www.mrexcel.com/forum/excel-questions/1096560-vlookup-problem.html or this: https://support.office.com/en-us/article/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1

 

[HizExceLenCy]

Thanks for the quick reply. To be honest, it's a little over my head, without an explanation of the formula he's using.

Can I upload the workbook in question? How can you see what I've done?

 

[sandy666]

2nd link contain description, explanation and examples for VLOOKUP()

if you want to show your work (desensitized) post a link to the shared excel file from OneDrive, GoogleDrive or any similar

 

[HizExceLenCy]

Ok, Will do.

more later...

 

[HizExceLenCy]

That's the link to my Excel spreadsheet that I uploaded at GoogleDrive...It's a "tiny" URL as you can see.

https://tinyurl.com/737cklist

 

[sandy666]

with :

=IF(ISNA(VLOOKUP(A2,Sheet2!$A$2:$B$41,1,0)),"Not found","")

see attached file

I did it bidirectionally, choose one

 

[HizExceLenCy]

Thank you Sandy very much for running the formula bidirectionally.

(re your Sig I wish I knew what you knew Because of the high number of "Not Found's" (I was only expecting around 10 at the most, but nothing like what the formula returned.

I'm sure the same item is referred to differently on one or the other sheets. For example, "Overhead Panel" vs. Ovhd Pnl". So, I have to go through it line by line, sheet by sheet anyway.

 

[sandy666]

You are welcome

it was based on your example without any detailed description so I think you need do what you said.
formula(s) works so it will be easier now

Have a nice day