Autofill cell reference

**dj.mics** · 08-11-2012, 07:36 AM

what formula I can use to autofill the cells with data from different sheets. I have included a base formula in cell B2.

Attached is a sample data.

I appreciate any help

**benishiryo** · 08-11-2012, 09:38 AM

hi dj.mics, your VLOOKUP is currently looking for an approximate match because you did not put a TRUE/FALSE or 1/0. i'm assuming you need to look for an exact match so here goes. try this in cell B2 & copy it across & downwards:
=VLOOKUP($A2,INDIRECT("'"&B$1&"'"&"!"&"A2:E11"),5,0)

**dj.mics** · 08-11-2012, 09:57 PM

im sorry for the confusion.. lets assume that i already have that in the formula..

=VLOOKUP($A2,'Day 1'!$A$2:$E$11,5,TRUE)

I want to know what can i do about the formula so that when i drag it sideways it will fill the following:

B2 = VLOOKUP($A2,'Day 1'!$A$2:$E$11,5,TRUE)
C2 = VLOOKUP($A2,'Day 2'!$A$2:$E$11,5,TRUE)
D2 = VLOOKUP($A2,'Day 3'!$A$2:$E$11,5,TRUE)
E2 = VLOOKUP($A2,'Day 4'!$A$2:$E$11,5,TRUE)
F2 = VLOOKUP($A2,'Day 5'!$A$2:$E$11,5,TRUE)

Technically, only need the sheet name/number to change when dragging the formula..

Any advise?

thanks you very much for any help...

**benishiryo** · 08-12-2012, 06:40 AM

forgot to tell you that your B2 has a space behind. Type "Day 1" without the quotes instead of "Day 1 ". My formula i given still will work. it is looking inside your cells B1:F1 & take the worksheet name.

and it's supposed to be FALSE/0, not TRUE.
FALSE/0 - Exact match
TRUE/1 - Approximate Match

i attached the eg in case you dont get it