Need help whit an Lookup problem.

Dear users. I hope one of you might know the answer to this question.

I am currently trying to make an excel ark for the boat where I am working right now.
Here is the problem
I have created this worksheet.
Look at the attachment
Now I want to create a another sheet where I can look up the date the date that I have entered.
I don’t know how to program a bottom or made the cells auto full out whit the info from the other sheet.
Hope someone can help me whit this problem.
Best Regards
Allan Bamse Sørensen
Esvagt A/S

Excel probelm
Nick's picture

have you tried a vlookup ?

have you tried a vlookup ?

I am fairly new to this chain

I am fairly new to this chain of Programing, have used excel for many years, but not like this, so must say No have not tried a Vlookup, but am going to try and look at it, so hope I might get it to do want I want :-)

Nick's picture

take a look at

Nick Thank you so much for

Nick
Thank you so much for your help, I figured it out :-)
=VLOOKUP($C$1;'2012'!1:1048576;2;FALSE)

Nick's picture

If you'd like to say thanks,

If you'd like to say thanks, I need as many "likes" as possible:
; - >

I have come up whit this so

I have come up whit this so far
=VLOOKUP(Oversigt!C1:E1;'2012'!1:1048576;2;FALSE)
But that just returns the #VALUE!