Simple VLOOKUP...

Hopefully somebody can figure out my stupid mistake (at least that seems to be the case). I'm trying to do a simple vlookup between two spreadsheets (in the same workbook). I want to look up the part number on one sheet and find the part number's description on the other sheet (to fill in missing information on the first sheet). However I can't get it to work. I don't know if I have syntax wrong or some other simple human error. My pride is suffering...

The workbook is attached. Any help would be great. Thanks!

Thanks, Andy.

The lookup range had the TYPE as the first column rather than PartNumber.

That was indeed my problem. I didn't realize/forgot (take your pick) that was necessary.

You where not using the List sheet but the Table sheet.

I forgot to change the range back to LIST when I was fiddling around with things trying to find a fix. Oops.

you have move type no after part no.
I attached the solved file with this post open that file you see the your problem is solved now.

I think that your problem will be solved
if not then please tell me the problem
i will try to solve your problem

from: Raj Kumar
[email protected]

@kunvarkumarraj

I got everything sorted out and working how I'd like it to work. Thanks for the input, though.