lookup and get data function

**germanjulian** · 06-07-2007, 09:50 AM

Hi,

I done my research on v and h lookup and index and match and none seem to do what I want. I have 2 Sheet.

Sheet one has a unique ID and a row of functions which check sheet2:

A B
1 Unique ID "function I want to create"
2 Unique ID2 "function I want to create"

Sheet 2 has dates descending from A down and in B C D E etc. we could have one of those Unique IDs so:
A B C D etc.
Date UniqueID2 Uni88 Uni2992
Date2 Unie 8282
Date3 etc.

unique id will never appear more then ones.
Basically we need to track on what date which "UniqueID" has been done on sheet 1 B!

thanks

PS: why doesnt v lookup due =VLOOKUP("a",Sheet2!A1:E20,1)

**NBVC** · 06-07-2007, 09:59 AM

Try something like:

Please Login or Register  to view this content.

where A2 is the location of the first Unique id to match.
Sheet2!B1:E20 houses the mixed array of unique ID's (never duplicated)
Sheet2!A1:A20 houses the dates corresponding to the entries.

adjust all ranges to suit.

**germanjulian** · 06-07-2007, 11:40 AM

mhh cheers but no.

the unique ID are actually text strings but that actually seems to work but the value that gets returned is a weird number? I take it this is because we do a sumproduct which wont really help me if I try to return a date

for example excel returns 39221 but the date is 19/05/07

**NBVC** · 06-07-2007, 12:21 PM

I should've mentioned that you may need to format the result cells as date.

i.e. Format|Cells >> Number tab then select Date and choose desired format.

lookup and get data function

LinkBack

Thread Tools

Rate This Thread

Display

lookup and get data function

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions