locate data with 2 variables

[Martindelica]

Hi there, this next tasks requires me to upload the following file. I need Excel to first look at the date in CellA2, then look at B1 to see the required data and put it into B2. Same for C2. There are 8 different items. Please see attached for specific's. Thanks kindly, martin.

[NBVC]

Try:

Please Login or Register  to view this content.

copied down and over

[Ron Coderre]

Here you go....try this:

Please Login or Register  to view this content.

Does that help?

[Martindelica]

Absolutley Ron, they both work great. One more thing. What if in my date column I had for example Jan 4, 2003 13:30. For some reason the VLOOKUP won't work with the time. Is there an add on to the formula I can use?

Kindest regards,
Martin.

[Ron Coderre]

If there are Date/Times in the HelioData sheet, then I'd use a variation of the same approach:

Please Login or Register  to view this content.

Does that help?

[Martindelica]

Hi Ron, no I couldn't get it to work. I have attached the sheet. Still wont work with the time element present.

Warmest regards,
Martin.

[Ron Coderre]

Posting the workbook helped immensely. I thought you wanted to lookup a date against a date/time value.

Please Login or Register  to view this content.

I prefer to avoid array formulas....most of the people I work with NEVER remember to CTRL+SHIFT+ENTER after they edit them. :\

Does that help?

[Martindelica]

Awesome Ron, your a credit to the site. Thanks again for your help.

Warmest regards,
Martin.

[Ron Coderre]

..and thanks for the kind words, Martin...I'm just glad I could help.