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
»
- Bamse's blog
- Login or register to post comments
- 2933 reads
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 :-)
take a look at
take a look at these:
http://excelexperts.com/Excel-Tips-VLOOKUP-INDEX-MATCH%20
http://excelexperts.com/Excel-Tips-VLOOKUP
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)
If you'd like to say thanks,
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!