Hi
I am trying to get the following:
I have data in one sheet containing various weeks. I have created a control box so yuo can select a week but it isn't working properly because i have the syntax in the formula wrong.
My Syntax in the cells goes like this:
=(IF(ISNA(VLOOKUP(A13,'31 day patients data radio'!A:H,8,FALSE)), "-",(VLOOKUP(A13,'31 day patients data radio'!A:H,8,FALSE))))
In A13 there is a key. In the other sheet in column H is the key but i want to say:
If The key matches whats in A13 then put the value in column F in the cell.
Can anyone help? got to submit this by tomorrow
Thanks
Bookmarks