Vlookup

hey this is my first post so if I'm not posting properly or some such, just let me know....

anyways, I have a bunch of cells in a column which contain the following in variation :

=(IF(ISNA(VLOOKUP("Name",tuesday1,3)),VLOOKUP("Name",tuesday2,3),VLOOKUP("Name",tuesday1,3)))

where name is always different. somewhere else I have a bunch of ranges with a name in one column followed by two times. my problem is that entering one name and time happens to modify all cells for a name falling under the entered name. I'm new to this type of excel stuff so please help. thanks =].

Attached is the thing im currently working on with a few examples, I tried what you suggested in C37-C38, but still no luck. the repetition is shown by the examples.

The top part of the sheet is a lineup of stations with the bottom part then filling out the hours each employee must work.

make a slight changes on the formula instead of type name everytime like

=(IF(ISNA(VLOOKUP("ALDRIDGE",monday1,2)),VLOOKUP("ALDRIDGE",monday
2,2),VLOOKUP("ALDRIDGE",monday1,2)))

change to

=(IF(ISNA(VLOOKUP("$A37",monday1,2)),VLOOKUP("$A$37",monday2,2),VLOOKUP("$A37",monday1,2)))


Cheers
Arvind

Originally Posted by aravindhan_31

make a slight changes on the formula instead of type name everytime like

=(IF(ISNA(VLOOKUP("ALDRIDGE",monday1,2)),VLOOKUP("ALDRIDGE",monday
2,2),VLOOKUP("ALDRIDGE",monday1,2)))

change to

=(IF(ISNA(VLOOKUP("$A37",monday1,2)),VLOOKUP("$A$37",monday2,2),VLOOKUP("$A37",monday1,2)))


Cheers
Arvind

is this suppose to resolve it? , I mean the quotes make it appear as a string rather than a cell reference and then making it a cell reference rather than typing the name didn't fix anything.