Vlookup or Index Help Required

**Grahamfeeley** · 04-21-2017, 10:19 PM

Hi can someone please help me here,
I have 2 sheets involved
I wish to fill cells with the formula to get cell data
formula to go in to A2 Book1 Sheet1

Book1 Sheet1

Fields, Sheet1
required cell to return is Column 6

I start with blank column in Book1 sheet1

data starting in B2 with a dynamic range each day
must lookup B2+C2 in Book1 Sheet1
must match
Fields Sheet1 A2+B2
and return the data in column 6

Hope this makes sense to someone there

Regards
Graham

**krjoshi** · 04-22-2017, 02:03 AM

Hi Graham,

Could you please upload a sample workbook with sample data for better understanding your requirement.

Thanks,
Joshi

**FDibbins** · 04-22-2017, 02:32 AM

Agree we need to see some sample data to help.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.